hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Swagatika Tripathy <swagatikat...@gmail.com>
Subject Re: READING FILE FROM MONGO DB
Date Tue, 01 Apr 2014 08:05:18 GMT
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" <swagatikat856@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.haldar@accenture.com> wrote:

> Are you swagatika mohanty?
>
>
>
>
>
>
> Thanks,
> Shouvanik
>
>
> -----Original Message-----
> From: Siddharth Tiwari [mailto:siddharth.tiwari@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" <
> swagatikat856@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
>
>

Mime
View raw message