Sqoop Forum

Sqoop –meta-connect

  • #57073
    Daro Sdf

    I get error when i try invoke command: sqoop job –meta-connect jdbc:hsqldb:hsql://localhost:16000/sqoop –list

    6041 [main] ERROR org.apache.sqoop.tool.JobTool – I/O error performing job operation: java.io.IOException: Exception creating SQL connection
    at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:216)
    Caused by: java.sql.SQLException: socket creation error
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)

    If i invoke command: sqoop metastore i get info that server started on port 16000

    My sqoop-site.xml
    <description>The connect string to use when connecting to a
    job-management metastore. If unspecified, uses ~/.sqoop/.
    You can specify a different path here.
    <description>Path to the shared metastore database files.
    If this is not set, it will be placed in ~/.sqoop/.

    <description>Port that this metastore should listen on.

    If i comment above settings as its default and try invoke command: sqoop job –list it works
    Where is the problem with –meta-connect ?

to create new topics or reply. | New User Registration

  • Author
  • #57399
    Saravanan Mohan

    Try running the command without meta connect option. Verify it is listing jobs. If it runs success, then your metastore wasn’t configured properly.

The topic ‘Sqoop –meta-connect’ is closed to new replies.

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.