Can you share your create table ddl for table name docs?
Select statement does not need all those details. Those are part of create
table DDL only.
On Fri, Sep 13, 2013 at 4:24 PM, Sandeep Nemuri nhsande...@gmail.comwrote:
Hi nithin
Thanks for your help
I have used this query in hive to
Hi nithin
Thanks for your help
I have used this query in hive to retrieve the data from mongodb
add jar /usr/lib/hadoop/lib/mongo-2.8.0.jar;
add jar /usr/lib/hive/lib/hive-mongo-0.0.3-jar-with-dependencies.jar;
select * from docs
input format org.yong3.hive.mongo.MongoStorageHandler
with
Thanks all
i am trying to import data with this program
but when i compied this code i got errors
Here is the code
import java.io.*;
import org.apache.commons.logging.*;
import org.apache.hadoop.conf.*;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.io.*;
import
Hi Nitin Pawar,
I have checked That link .There data is importing
from Hive-mongo.
But my requirment is to import data from mongo-hive.
On Thu, Sep 12, 2013 at 3:49 PM, Nitin Pawar nitinpawar...@gmail.comwrote:
Sandip,
Did you try using hive-mongo
try creating table with your existing mongo db and collection see the data
can be read by the user or not.
What you need to do is mongo collection column mapping exactly with same
names into hive column definition.
if you can not see mongo data from hive query, do let me know what errors
do you
Hi every one ,
I am trying to import data from mongodb to hive . i
got some jar files to connect mongo and hive .
now how to import the data from mongodb to hive ?
Thanks in advance.
--
--Regards
Sandeep Nemuri
The docs are at https://github.com/mongodb/mongo-hadoop/tree/master/hive
You need to build mongo-hadoop, and then use the documented syntax to
create BSON tables in Hive.
On Wed, Sep 11, 2013 at 11:11 AM, Jitendra Yadav jeetuyadav200...@gmail.com
wrote:
Hi,
1. you may use Hadoop-mongodb
Hi,
1. you may use Hadoop-mongodb connector, create a map reduce program
to process your data from mongodb to hive.
https://github.com/mongodb/mongo-hadoop
2. As an alternative you can also use pig mongodb combination to get
the data from mongodb through pig, then after you can create a table
Hi,
You can use Talend to import data from mongodb to hive
More informations here : http://www.talend.com/products/big-data
2013/9/11 Sandeep Nemuri nhsande...@gmail.com
Hi every one ,
I am trying to import data from mongodb to hive . i
got some jar files to connect