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 <kish...@techdigita.in>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/