Pig count query

Question

I have to find out the number of students who scored less than 5. I have loaded the file. I am using a filter for grade< 5
I am not getting how to take the count now. Can anyone please help

Answer 1

Refer to COUNT

A = LOAD 'student.csv' using PigStorage(',') as (name:chararray,grade:int);
B = FILTER A by grade < 5;
C = GROUP B BY name;
D = FOREACH C GENERATE COUNT(B);
DUMP D;