RE: Loading data from a CSV file which has '\n' character in a field

2015-07-23 Thread Divya Gehlot
r 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 > > > > -Original Message- > From: Divya Gehlot [mailto:divya.htco...@gmail.com] > Sent: Wedn

RE: Loading data from a CSV file which has '\n' character in a field

2015-07-23 Thread Sunilmanohar Kancharlapalli -X (sunkanch - ZENSAR TECHNOLOGIES INC at Cisco)
pies of this message. For corporate legal information go to: http://www.cisco.com/web/about/doing_business/legal/cri/index.html -Original Message- From: Divya Gehlot [mailto:divya.htco...@gmail.com] Sent: Wednesday, July 22, 2015 11:49 PM To: user@pig.apache.org Subject: Re: Loading data from a CS

Re: Loading data from a CSV file which has '\n' character in a field

2015-07-22 Thread Divya Gehlot
you can try this http://pig.apache.org/docs/r0.7.0/udf.html#Load%2FStore+Functions On 23 July 2015 at 09:24, Sunilmanohar Kancharlapalli -X (sunkanch - ZENSAR TECHNOLOGIES INC at Cisco) wrote: > I am trying to load a csv file which has ā€˜\nā€™ character in the field and > Pig is considering that

Loading data from a CSV file which has '\n' character in a field

2015-07-22 Thread Sunilmanohar Kancharlapalli -X (sunkanch - ZENSAR TECHNOLOGIES INC at Cisco)
I am trying to load a csv file which has '\n' character in the field and Pig is considering that as a new record. I am missing the data in that particular column and getting additional records in the output table. I am using d = LOAD '/location/of/the/file/name_of_the_fiel.csv' USI