How can i find each professional count and age count of a particular country( for eg US) in pig

Question

this is the example. from this i want to find each professional count and each age group count.

filter_data = FILTER customer by loc=='us';          
grunt> grp_data1 = GROUP filter_data by age;                                   
grunt> cnt_data = FOREACH grp_data1 generate group,COUNT(customer);

Answer 1

You are trying to use a GROUP BY statement using filter_data. So, the same variable name has to be used inside COUNT function.

grunt> grp_data1 = GROUP filter_data by age;                                   
grunt> cnt_data = FOREACH grp_data1 generate group, COUNT(filter_data);