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

"Memory Group by" step - Minimum aggregation doesn't work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 4.4.0 GA (4.8.0 GA Suite Release)
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
    • 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

      Follow up from bug PDI-10250 but for the Memory group by step:

      Make sure the following variables are correctly respected:

      For backward compatibility, we introduce two new variables that effect aggregate functions (please see also the linked cases to follow up on other steps):

      KETTLE_AGGREGATION_MIN_NULL_IS_VALUED

      Description: Set this variable to Y to set the minimum to NULL if NULL is within an aggregate. Otherwise by default NULL is ignored by the MIN aggregate and MIN is set to the minimum value that is not NULL. See also the variable KETTLE_AGGREGATION_ALL_NULLS_ARE_ZERO.

      KETTLE_AGGREGATION_ALL_NULLS_ARE_ZERO

      Description: Set this variable to Y to return 0 when all values within an aggregate are NULL. Otherwise by default a NULL is returned when all values are NULL.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alena_khamitsevich Alena Khamitsevich (Inactive)
              Reporter:
              kamapcuc Gregory
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: