Store pig result in a text file

Question

Hi stackoverflow community;

i'm totally new to pig, i want to STORE the result in a text file and name it as i want. is it possible do this using STORE function.

My code:

a = LOAD 'example.csv' USING PigStorage(';');

b = FOREACH a GENERATE $0,$1,$2,$3,$6,$7,$8,$9,$11,$12,$13,$14,$20,$24,$25;

STORE b INTO ‘myoutput’;

Thanks.

Answer 1

Yes you will be able to store your result in myoutput.txt and you can load the data into file with any delimiter you want using PigStorage.

a = LOAD 'example.csv' USING PigStorage(';');
b = FOREACH a GENERATE $0,$1,$2,$3,$6,$7,$8,$9,$11,$12,$13,$14,$20,$24,$25;
STORE b INTO ‘myoutput.txt’ using PigStorage(';');