PIG

Grunt>A = LOAD '/user/cloudera/mymovie' using PigStorage(',') as (col1: int,col2:chararray,col3:chararray,col4:chararray,col5:chararray);


Grunt> DUMP A;

Grunt> B = FOREACH A generate col1,col4,col5;

Grunt> DUMP B;