Sqoop Forum

Not able to import table from database

  • #45490
    Pavan Kumar
    Member

    Hi .. I am using the following cmd:
    >sqoop import –connect jdbc:sqlserver://localhost –table My_Practice –username sa -P –target-dir /userPavan/table -m 1
    Although i didnt give the database name, MyData above, able to import the table successfully to HDFS.

    But if i specify the data base as below, error is occurred.
    >sqoop import –connect jdbc:sqlserver://localhost/MyData –table My_Practice –username sa -P –target-dir /userPavan/table -m 1

    Can anyone please help me out..!!!!!!!

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #46233
    Dave
    Moderator

    Hi Pavan,

    Can you try using:

    sqoop import –connect jdbc:sqlserver://localhost –table MyData.My_Practice –username sa -P –target-dir /userPavan/table -m 1

    However I have not had issues using your second query in your post – what is the error which is thrown?

    Thanks

    Dave

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

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

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.