Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: BUG ? group by on big integer (or string)

  1. #1
    Join Date
    Dec 2014
    Posts
    2

    Default BUG ? group by on big integer (or string)

    I am using kettle for this input:
    216172782230671819 ;1
    216172782230672224 ;1
    216172782230672403 ;1
    216172782230673534 ;1
    216172782230673659 ;1
    216172782230673772 ;1
    216172782230673778 ;1
    216172782230673891 ;1
    216172782230673996 ;1
    216172782230674407 ;1
    216172782230674638 ;1
    216172782230674723 ;1

    I want use "group by" for grouping and counting, (key : first field (field_000)), but "group by" can't recognize that.
    p.s: I am trying "sort" before "group by". (If "length of first field" <= 8 characters, it works correctly)

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Works perfectly well over here.
    Prepare a demo and we'll have a look.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Dec 2014
    Posts
    2

    Default

    Yes, you are right. Excuse me for this wrong post (BUG Report).
    The data above is a sample of my whole data and when I check the output of the main data by MS Excel some of results were not true then I use simple text file as output and when check data all things were true. Excuse me again!

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.