Pig: scalar has more than one row in the output

Vote count:

0

I was trying to get the average age of all employees. There are multiple employees with same age in the .txt file.

records = LOAD 'file:/home/Documents/PigDemo_CommaSep.txt' USING PigStorage(',') AS (firstname:chararray,lastname:chararray,age:int,sex:chararray);
grouped = GROUP records BY age;

When I try to dump the grouped then I get this error: scalar has more than one row in the output. Though the message is clear enough, but I am not able to understand where is the violation in contract. Please advice.

asked 1 min ago

user182944

960

Pig: scalar has more than one row in the output