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

Group by and Memory group by ignores NULL values ("sum" aggregation)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 4.2.0 GA (4.0.0 GA Suite Release)
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
    • Environment:
      Microsoft Windows Server 2003 (64-bit), Service Pack 2

      Java(TM) Platform, Standard Edition for Business (build 1.5.0_22-b03)
      Java HotSpot(TM) Client VM (build 1.5.0_22-b03, mixed mode)

    • Story Points:
      2
    • 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:
      Pervach

      Description

      Unusual behaviour of the Group by operation in PDI - performing a "sum" over a field containing null and not null values don't brings back the expected result, which is NULL. The sum of a NULL and a 100 field value, turns back the result of 100, which is not correct since "100" + "I don't know" = "I don't know"!

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alena_khamitsevich Alena Khamitsevich (Inactive)
              Reporter:
              dgeorgieva Desislava Georgieva
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h
                  4h