grouping a relation in pig

[#1]

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.

AU

[#2 · Accepted solution]

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!

[#3]

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

[#4]

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