Re: populating xml data in hive

2012-11-20 Thread Nitin Pawar
You can simply write a mapreduce job which will do the job for you That will be readily available for hive table On Nov 20, 2012 2:29 PM, "iwannaplay games" wrote: > How to preprocess data where millions of records are there out of > which only few thousands contain xml data > > > On 11/20/12, Ni

Re: populating xml data in hive

2012-11-20 Thread Bejoy KS
Subject: Re: populating xml data in hive How to preprocess data where millions of records are there out of which only few thousands contain xml data On 11/20/12, Nitin Pawar wrote: > Hive currently supports only new line as record separator. If you got > newline in in column values then yo

Re: populating xml data in hive

2012-11-20 Thread iwannaplay games
How to preprocess data where millions of records are there out of which only few thousands contain xml data On 11/20/12, Nitin Pawar wrote: > Hive currently supports only new line as record separator. If you got > newline in in column values then you will need to preprocess your data and > remov

Re: populating xml data in hive

2012-11-20 Thread Nitin Pawar
Hive currently supports only new line as record separator. If you got newline in in column values then you will need to preprocess your data and remove new line from column values On Nov 20, 2012 1:30 PM, "iwannaplay games" wrote: > Hi All, > > I have a csv file ( separated by |) where data is li