Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Getting extra record in GROUP BY step

  1. #1
    Join Date
    Jul 2007
    Posts
    4

    Default Getting extra record in GROUP BY step

    I am having an issue with the GROUP BY step outputing a record even though there are no records being sent into the step. In Kettle 2.5, if there were no records input into a GROUP BY step then no records would be output from the step. However, in Kettle 3.01, if no records are input into a GROUP BY step, then 1 record is output with values for the aggregate fields and nulls for all remaining fields.

    Is this a bug or is this by design?

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    By design. It was conceived a bug when no record was emitted as an aggregation of the 0 input records.
    If you do a count of the input records, you want to get the number 0 in one record.

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.