Hi All, I am trying to automate the loading process using Pig from a CSV file using piggybank's CSVExcelStorage.
When I am about to store, I want a UDF that needs to be applied to each and every column of that excel. Right now, I am using B = load 'path/to/input/file' using org.apache.pig.piggybank.storage.CSVExcelStorage( , , , , ); C = foreach B generate function($0), function($1), function($2) , function($3), function($4), function($5); But for automation, I am sending the path to input file as an argument and the number of columns might change every time. Please let me know if there is something which is helpful in this situation. Thanks Sunil [http://www.cisco.com/web/europe/images/email/signature/logo05.jpg] Sunilmanohar Kancharlapalli Engineer - IT sunka...@cisco.com Phone: Cisco Systems Limited US Cisco.com<http://www.cisco.com> [Think before you print.]Think before you print. This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message. For corporate legal information go to: http://www.cisco.com/web/about/doing_business/legal/cri/index.html
