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