Re: Create hive table to support multiple delimiters

2014-04-30 Thread unmesha sreeveni
as > MAP data type and then get the value of appid etc. > > > > Thanks, > > Moiz > > > > *From:* unmesha sreeveni [mailto:unmeshab...@gmail.com] > *Sent:* Wednesday, April 30, 2014 3:39 PM > *To:* User - Hive > *Subject:* Re: Create hive table to support m

RE: Create hive table to support multiple delimiters

2014-04-30 Thread Arafat, Moiz
I think \x22 represent double quotes . Try storing the second column as MAP data type and then get the value of appid etc. Thanks, Moiz From: unmesha sreeveni [mailto:unmeshab...@gmail.com] Sent: Wednesday, April 30, 2014 3:39 PM To: User - Hive Subject: Re: Create hive table to support

Re: Create hive table to support multiple delimiters

2014-04-30 Thread unmesha sreeveni
So your delimiters are | and \x22? Can you show me how should be your table structure. So that I can help you On Wed, Apr 30, 2014 at 3:14 PM, Kishore kumar wrote: > > Hi All, > > My input data looks like below as | delimited and I want to extract appid, > appname, bundleid etc, please help m