you can always write customUDF for your needs
On Tue, Apr 1, 2014 at 1:35 PM, Swagatika Tripathy
<swagatikat...@gmail.com>wrote:
> Do we hv a for loop concept in hive to iterate through the array elements
> n display them. We need an alternative for explode method
> Well you cN use Json serde for this
>
> Sent from my iPhone
>
> On Mar 26, 2014, at 8:40 PM, "Swagatika Tripathy" <swagatikat...@gmail.com>
> wrote:
>
> Hi ,
> The use case is we have some unstructured data fetched from Mongo DB and
> stored in a particular location. Our task is to load those data into our
> staging and core hive tables in form of rows and columns.eg if the data
> is in key value pair like:
> {
> Id: bigint(12346),
> Name:string(ABC),
> Subjects:
> {Subject enrolled:
> Subjects:
> [eng ,math]
> }
> {Game enrolled:
> [Football,cricket]
> }
> This is just a very simple eg fr reference but we have a complex Json
> format with huge amount of data.
>
> So, in this case how can we load it into hive tables and hdfs?
> On Mar 26, 2014 10:59 PM, <shouvanik.hal...@accenture.com> wrote:
>
>> Are you swagatika mohanty?
>>
>>
>>
>>
>>
>>
>> Thanks,
>> Shouvanik
>>
>>
>> -----Original Message-----
>> From: Siddharth Tiwari [mailto:siddharth.tiw...@live.com]
>> Sent: Wednesday, March 26, 2014 10:03 AM
>> To: user@hive.apache.org
>> Subject: Re: READING FILE FROM MONGO DB
>>
>> Hi Swagatika
>> You can create external tables to Mongo and can process it using hive.
>> New mongo connectors have added support for hive. Did you try that?
>>
>> Sent from my iPhone
>>
>> > On Mar 26, 2014, at 9:59 AM, "Swagatika Tripathy" <
>> swagatikat...@gmail.com> wrote:
>> >
>> > Hi,
>> > We have some files stored in MongoDB , mostly in key value format. We
>> need to parse those files and store it into Hive tables.
>> >
>> > Any inputs on this will be appreciated.
>> >
>> > Thanks,
>> > Swagatika
>> >
>>
>>
>> ________________________________
>>
>> This message is for the designated recipient only and may contain
>> privileged, proprietary, or otherwise confidential information. If you have
>> received it in error, please notify the sender immediately and delete the
>> original. Any other use of the e-mail by you is prohibited. Where allowed
>> by local law, electronic communications with Accenture and its affiliates,
>> including e-mail and instant messaging (including content), may be scanned
>> by our systems for the purposes of information security and assessment of
>> internal compliance with Accenture policy.
>>
>> ______________________________________________________________________________________
>>
>> www.accenture.com
>>
>>
--
Nitin Pawar
