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

Denormaliser step: KettleValueException on Minimum Aggregation only

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 7.0.0.1 GA
    • Fix Version/s: 7.1.0 GA
    • Component/s: Step
    • Labels:
      None
    • 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.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide

      1. Open the sample "Denormaliser - data conversion and aggregation"
      2. Edit the row denormaliser step and change the aggregation of all columns from Sum to Minimum
      3. Run transformation
      4. KettleValueException appears in log, "month01 Integer(5) : There was a data type error: the data type of java.lang.String object [1111] does not correspond to value meta [Integer(5)]"

      Show
      1. Open the sample "Denormaliser - data conversion and aggregation" 2. Edit the row denormaliser step and change the aggregation of all columns from Sum to Minimum 3. Run transformation 4. KettleValueException appears in log, "month01 Integer(5) : There was a data type error: the data type of java.lang.String object [1111] does not correspond to value meta [Integer(5)] "

      Description

      The minimum aggregation fails if the type of the input and output fields are different. Both sum and maximum aggregations handle this situation just fine.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              upihin Uladzimir Pihin (Inactive)
              Reporter:
              kcaswick Kevin Caswick
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: