hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Tiwari <siddharth.tiw...@live.com>
Subject Re: READING FILE FROM MONGO DB
Date Thu, 27 Mar 2014 05:29:51 GMT
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