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
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
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
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 *