I belive you are having | as delimiter And you can create the table using this link: http://www.unmeshasreeveni.blogspot.in/2014/04/how-to-create-tables-in-hive.html
On Wed, Apr 30, 2014 at 3:59 PM, Arafat, Moiz <[email protected]>wrote: > 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:[email protected]] > *Sent:* Wednesday, April 30, 2014 3:39 PM > *To:* User - Hive > *Subject:* Re: Create hive table to support multiple delimiters > > > > 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 <[email protected]> > wrote: > > > Hi All, > > My input data looks like below as | delimited and I want to extract appid, > appname, bundleid etc, please help me to create hive table , > > > |0|{\x22appid\x22:\x228\x22,\x22appname\x22:\x22CONVX-0008\x22,\x22bundleid\x22:\x22com.zeptolab.timetravel.free.google\x22}|14| > > > > -- Thanks, > > *Kishore * > > > > > > -- > > *Thanks & Regards * > > > > *Unmesha Sreeveni U.B* > > *Hadoop, Bigdata Developer* > > *Center for Cyber Security | Amrita Vishwa Vidyapeetham* > > http://www.unmeshasreeveni.blogspot.in/ > > > > > -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Center for Cyber Security | Amrita Vishwa Vidyapeetham* http://www.unmeshasreeveni.blogspot.in/
