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

Group by: "Minimum" aggregation function returns null even if non-null values are present

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Duplicate
    • Affects Version/s: 3.2.0 GA
    • Fix Version/s: 3.2.5
    • Component/s: Step
    • Labels:
      None
    • 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.

      Description

      "Minimum" aggregation function returns null even if non-null values are present. This is not the behaviour of SLQ, that returns the minimum of non-null values if any. it is a severe problem because if I have several columns of wich i need to calcumate the minimum, but each of them contains null values, I cannot use "first non null values", because ordering on field would cause erroneous results for the other fields. Same problem with filtering: filtering values for one field would cause possible loss of data for other fields.
      Since SQL behaviour is different I think this should be fixed. But I guess also another function (e.g. "Minimum (not null)") can be implemented.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mcasters Matt Casters (Inactive)
              Reporter:
              biuri Iuri Fanti
              Votes:
              3 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: