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