question Re: How to get the desired grouping result pig in Support Questions

How to get the desired grouping result pig

AndresUrrego — Sun, 18 Aug 2019 06:13:51 GMT

Hi guys, I have been struggling with my Pig code and I haven't arrived at desired result so this is why I'm knocking you guys. Well, I have a file with some information and my idea is to get a counting by reference number. so as an overview I have done:

So the third step worked but the problem is that it generates a huge tuple to include the reference number by each tuple in my grouping bag that contains the number so the output it's like:

Then I tried the fourth step but although I got the counting list I missed the reference_number so I would like to get the same list but just once the reference code.

Thanks so much for your help team. @Lester Martin

Re: How to get the desired grouping result pig

poojachawda_10 — Tue, 06 Jun 2017 14:23:12 GMT

Hi @Andres Urrego,

You need to modify your third step like.

october_total_station = FOREACH october_station_gr GENERATE FLATTEN(group) , COUNT(october.s_station);

Re: How to get the desired grouping result pig

AndresUrrego — Wed, 07 Jun 2017 03:00:54 GMT

got it, I start to understand how works the grouping in Pig . actually to be sure i did:

october_gr_counting = FOREACH october_station_gr GENERATE group , COUNT(october)

thanks so much buddy.