Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-17270

Sort rows : Cannot sort Internet Address Types

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 7.1.0 GA, 8.0.0 GA, 8.0.0.5 GA
    • Fix Version/s: 8.2.0 GA
    • Component/s: Step
    • Labels:
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Steps to Reproduce:
      Hide

      Steps to Reproduce

      1. Double click "spoon.bat".
      2. Open the attached KTR file.
      3. Modify the path of the CSV file.
      4. Run the transformation.

      Show
      Steps to Reproduce 1. Double click "spoon.bat". 2. Open the attached KTR file. 3. Modify the path of the CSV file. 4. Run the transformation.

      Description

      Internet Address type sort is not working as expected. When you run the attached transformation with log level set to Basic then the transformation completes without any issue.

      But when you run the same transformation with Row Level(very detailed) logging then we see the below error.

      2018/05/16 14:47:38 - Sort rows.0 - ERROR (version 8.0.0.3-195, build 8.0.0.3-195 from 2018-02-21 11.56.47 by buildguy) : Unexpected error
      2018/05/16 14:47:38 - Sort rows.0 - ERROR (version 8.0.0.3-195, build 8.0.0.3-195 from 2018-02-21 11.56.47 by buildguy) : java.lang.ClassCastException: java.net.Inet4Address cannot be cast to [B
      2018/05/16 14:47:38 - Sort rows.0 - 	at org.pentaho.di.core.row.value.ValueMetaInternetAddress.getInternetAddress(ValueMetaInternetAddress.java:89)
      2018/05/16 14:47:38 - Sort rows.0 - 	at org.pentaho.di.core.row.value.ValueMetaInternetAddress.getString(ValueMetaInternetAddress.java:208)
      2018/05/16 14:47:38 - Sort rows.0 - 	at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:319)
      2018/05/16 14:47:38 - Sort rows.0 - 	at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:828)
      2018/05/16 14:47:38 - Sort rows.0 - 	at org.pentaho.di.trans.steps.sort.SortRows.passBuffer(SortRows.java:510)
      2018/05/16 14:47:38 - Sort rows.0 - 	at org.pentaho.di.trans.steps.sort.SortRows.processRow(SortRows.java:447)
      2018/05/16 14:47:38 - Sort rows.0 - 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      2018/05/16 14:47:38 - Sort rows.0 - 	at java.lang.Thread.run(Unknown Source)
      

        PractiTest Integration




          Attachments

          1. 1583.ktr
            13 kB
          2. IN_InternetAddressSort01.csv
            0.1 kB
          3. Spoon_error.log
            6 kB
          4. test.txt
            0.0 kB

            Issue Links

              Activity

                People

                Assignee:
                eteixeira Emanuel Teixeira (Inactive)
                Reporter:
                gdev Gurudev
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: