HDP 2.0 MongoDB & Hive

to create new topics or reply. | New User Registration

This topic contains 2 replies, has 3 voices, and was last updated by  Dharanikumar Bodla 1 year, 5 months ago.

  • Creator
    Topic
  • #39960

    Is it possible to connect MongoDB to HDP 2.0 and utilize hive to query Mongo data? I am aware that the hadoop-mongo connector supports hadoop 2.0 in clouderas distribution, but couldnt find anything on support in HDP….could someone please shed some light on this? Any information will be useful. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

You must be to reply to this topic. | Create Account

  • Author
    Replies
  • #47800

    Dharanikumar Bodla
    Participant

    Hi to all,
    File import and export from Mongodb and vice-versa.

    data export from mongodb to hdfs.
    [hdfs@s ~]$ mongoexport -h localhost:27017 -d dbname -c collectionsname –query ‘{“_id” : ObjectId(“xxxxxxxxxx”)}’
    data import from hdfs to mongodb
    [hdfs@s ~]$ hadoop fs -text hdfs:/apps/x.txt | mongoimport –host localhost:27017 –db dbname –collection collectionname –type tsv -f –jsonArray

    Collapse
    #41766

    Alain Carey
    Participant

    I have exactly the same question. Please can some one give us some light ?

    Collapse
Viewing 2 replies - 1 through 2 (of 2 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.