Pig 2nd assignment error


2 Answer(s)


hi Vijaykanth,

Please provide the program which you were executing so that we can look at any kind of syntactical errors in your program.

Thanks

Hi DeZyre team,
Please find the below program that i tried executing. It is second assigment

runs = LOAD '/home/cloudera/Desktop/Batting.csv' AS (playerID:chararray, yearID:int,stint:int, teamID:chararray, lgID:chararray, G:int, G_batting:int, AB:int, R:int, H:int, 2B:int, 3B:int, HR:int, RBI:int, SB:int, CS:int, BB:int, SO:int, IBB:int, HBP:int, SH:int, SF:int, GIDP:int, G_old:int);

filter_runs = FILTER runs BY R !=1000;

grp_runs = GROUP runs BY playerID;

max_runs = FOREACH grp_runs GENERATE group;

DUMP max_runs;