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

Sort Rows - Cannot sort Internet Address Types

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 6.0.0 GA
    • Fix Version/s: 6.1.0 GA
    • Component/s: Step
    • Labels:
    • Story Points:
      0
    • PDI Sub-component:
    • 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
      1. Create a transformation
      2. Add a data grid, and populate some IP Addresses
      3. Add a Sort Rows step, and configure to sort by IP Address field
      4. Execute the transformation

      Expected Results: The transformation completes successfully, with no error in the log
      Actual Results: The transformation completes successfully, but there is an error in the log, and the data was not sorted

      1. Reconfigure the step to not sort ascending
      2. Execute the transformation

      Expected Results: The transformation completes successfully, with no errors in the log, with the records in the correct, descending order
      Actual Results: The transformation completes successfully, with errors in the log, and the data was not sorted

      Show
      Create a transformation Add a data grid, and populate some IP Addresses Add a Sort Rows step, and configure to sort by IP Address field Execute the transformation Expected Results: The transformation completes successfully, with no error in the log Actual Results: The transformation completes successfully, but there is an error in the log, and the data was not sorted Reconfigure the step to not sort ascending Execute the transformation Expected Results: The transformation completes successfully, with no errors in the log, with the records in the correct, descending order Actual Results: The transformation completes successfully, with errors in the log, and the data was not sorted

      Description

      The Sort Rows step is unable to sort rows based upon Internet Address values. The following error is given in the log after the transformation completes:

      2016/01/21 09:12:20 - Sort rows.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Error comparing rows: org.pentaho.di.core.exception.KettleValueException: 
      2016/01/21 09:12:20 - Sort rows.0 - IP Internet Address : Comparing values can not be done with data type : 10
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              rdomitrovich Robert Domitrovich
              Reporter:
              mtucker Matt Tucker
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: