question Re: grouping a relation in pig in Support Questions

grouping a relation in pig

AndresUrrego — Sun, 18 Aug 2019 06:49:12 GMT

Hi everyone, I'm trying to perform a grouping for a relation with the scheme below:

I have created a the group all for whole relation as:

total_station_trips_all = GROUP october ALL;

Finally I'm trying to get the counting for the column s_station from the scheme october like

Unfortunatelly I'm getting this error:

Please guys give me a light about this error i will appreciate so much.

Thanks so much.

Re: grouping a relation in pig

LesterMartin — Fri, 02 Jun 2017 23:32:00 GMT

You're not going to like it, but it is as simply as upper-casing "count" to be "COUNT". 😉

This brings up the larger issue around case-sensitivity in Pig. Generally, speaking case only really matters on alias names and things that end up being Java class names. Functions fall into that bucket, so just upper-case it and it'll work.

Additionally, you could simplify the code a bit to just do COUNT(october) instead of COUNT(october.s_station).

Good luck and happy Hadooping!

Re: grouping a relation in pig

AndresUrrego — Mon, 05 Jun 2017 19:32:38 GMT

thanks , tried and working. I have just to be more careful on my typing. I appriciate.

Re: grouping a relation in pig

LesterMartin — Thu, 08 Jun 2017 03:06:55 GMT

Excellent. Truthfully, the case sensitivity is a bit weird in Pig -- kind of like the rules of the English language. Hehe!