Manipulate a CSV file using Pig
I tried the following command to load a CSV file using Pig with the command:
A = LOAD '/USER/XYZ/PIG/FILENAME.ASC' USING PIGSTORAGE(',');
While it loaded and gave no error, cat a gave me a Directory does not
exist error. I'm new to Pig and know I did something very wrong there. How
do I check if it is indeed loaded? Or is loaded a misnomer, and the file
just exists on the HDFS?
Next, I'd like to cut a few columns of data from the CSV file and store it
in another file. How can I go about it?
I don't necessarily need the script/code, but if you could point me to the
right functions that will accomplish what I want to do, that would be
great. Thanks!