Pig 2nd assignment error
2 Answer(s)
DeZyre Support
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
Sep 01 2014 10:12 AM
Please provide the program which you were executing so that we can look at any kind of syntactical errors in your program.
Thanks
vijayakanth.bangalore
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;
Sep 02 2014 11:43 PM
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;