Unable to sqoop data from HDFS to Oracle

to create new topics or reply. | New User Registration

This topic contains 3 replies, has 1 voice, and was last updated by  Faisal ahmed Siddiqui 2 years ago.

  • Creator
  • #30046

    Hi ,
    I am trying to export a file on HDFS to Oracle database using sqoop and getting following error.
    here is my command.
    sqoop export –connect jdbc:oracle:thin:@host:port:SID –username xxxxxx –password xxxxxxx –export-dir /user/faisals/examples/output-data/ –table sqoop_test –input-fields-terminated-by ‘001’ –driver oracle.jdbc.driver.OracleDriver –verbose
    13/07/25 14:51:53 WARN sqoop.ConnFactory: Parameter –driver is set to an explicit driver however appropriate connection manager is not being set (via –connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time.
    13/07/25 14:51:53 INFO manager.SqlManager: Using default fetchSize of 1000
    13/07/25 14:51:53 INFO tool.CodeGenTool: Beginning code generation
    13/07/25 14:51:53 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
    13/07/25 14:51:53 DEBUG manager.SqlManager: Using fetchSize for next query: 1000
    13/07/25 14:51:53 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM sqoop_test AS t WHERE 1=0
    13/07/25 14:51:53 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: ORA-00933: SQL command not properly ended

    java.sql.SQLException: ORA-00933: SQL command not properly ended
    As we can see, sqoop generating a wrong SQL for oracle database not where to drill further.
    In addition, how does sqoop identified column mapping. lik e file on HDFS first column map to abc column in oracle etc?
    Highly appreciate your help..


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

The topic ‘Unable to sqoop data from HDFS to Oracle’ is closed to new replies.

  • Author
  • #30109

    wow this issue is resolved if we remove –driver argument..
    In addition, always mention user and tables upper case to avoid subsequent error
    Have fun :)


    Here is my sqoop version: Sqoop


    here is my oracle version & java driver.
    Oracle Database 11g Enterprise Edition Release – 64bit Production
    Note: this driver is working fine with the database from my local machine. and i have placed it under SQOOP_HOME/lib folder i,e. /usr/lib/sqoop/lib

Viewing 3 replies - 1 through 3 (of 3 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.