Pig script not dumping the data correctly

Question

Hi,
The following pig script is not dumping the columns correctly.
The 1st column is missing.

airportDetail = LOAD "/user/edureka_181724/hdpProject/airports_mod.dat" using PigStorage(",");
mappedAirportData = FOREACH airportDetail GENERATE (int)$1 AS airport_id,(chararray)$2 AS name,(chararray)$3 AS city,(chararray)$4 AS country,(chararray)$5 AS iata_code;
dump mappedAirportData

Answer 1

The first column is denoted by $0, the second with $1 and so on. So, the correct set of commands will be as below,

airportDetail = LOAD '/user/edureka_181724/hdpProject/airports_mod.dat' using PigStorage(',');

mappedAirportData = FOREACH airportDetail GENERATE (int)$0 AS airport_id,(chararray)$1 AS name,(chararray)$2 AS city,(chararray)$3 AS country,(chararray)$4 AS iata_code;

dump mappedAirportData;