Re: READING FILE FROM MONGO DB

2014-04-01 Thread Swagatika Tripathy
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

Re: READING FILE FROM MONGO DB

2014-04-01 Thread Nitin Pawar
, 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

READING FILE FROM MONGO DB

2014-03-26 Thread Swagatika Tripathy
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

Re: READING FILE FROM MONGO DB

2014-03-26 Thread Nitin Pawar
take a look at https://github.com/yc-huang/Hive-mongo On Wed, Mar 26, 2014 at 10:29 PM, 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

RE: READING FILE FROM MONGO DB

2014-03-26 Thread ashok.samal
MongoDB tores in Json Format. Use Json serde in hive while loading. -Ashok From: Swagatika Tripathy [mailto:swagatikat...@gmail.com] Sent: Thursday, March 27, 2014 12:59 AM To: user@hive.apache.org Subject: READING FILE FROM MONGO DB Hi, We have some files stored in MongoDB , mostly in key

Re: READING FILE FROM MONGO DB

2014-03-26 Thread Siddharth Tiwari
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

Re: READING FILE FROM MONGO DB

2014-03-26 Thread Shrikanth Shankar
https://github.com/mongodb/mongo-hadoop is from the mongo folks themselves Shrikanth On Wed, Mar 26, 2014 at 10:01 AM, Nitin Pawar nitinpawar...@gmail.comwrote: take a look at https://github.com/yc-huang/Hive-mongo On Wed, Mar 26, 2014 at 10:29 PM, Swagatika Tripathy

Re: READING FILE FROM MONGO DB

2014-03-26 Thread Swagatika Tripathy
Hi Siddharth, we need to store the unstructured data in internal hive tables. Have u tried something similar? On Wed, Mar 26, 2014 at 10:33 PM, Shrikanth Shankar sshan...@qubole.comwrote: https://github.com/mongodb/mongo-hadoop is from the mongo folks themselves Shrikanth On Wed, Mar

Re: READING FILE FROM MONGO DB

2014-03-26 Thread 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