sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bejo...@gmail.com
Subject Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command not properlyended error
Date Mon, 25 Jul 2011 17:16:04 GMT
Redirecting the message to new apache sqoop mailing list
Regards
Bejoy K S

-----Original Message-----
From: reju <rejurs@gmail.com>
Date: Mon, 25 Jul 2011 09:41:29 
To: Sqoop Users<sqoop-user@cloudera.org>
Reply-To: sqoop-user@cloudera.org
Subject: [sqoop-user] sqoop import shows ORA-00933: SQL command not properly
 ended error

sqoop import  -D  oraoop.disabled=true --driver
oracle.jdbc.OracleDriver --connect
jdbc:oracle:thin:@servername:port:SID --username username -password

password --table tablename --split-by fielname --warehouse-dir
warehusedirectory --hive-import --hive-table tabelname --verbose

11/07/25 12:37:43 DEBUG tool.BaseSqoopTool: Enabled debug logging.
11/07/25 12:37:43 WARN tool.BaseSqoopTool: Setting your password on
the command-line is insecure. Consider using -P instead.
11/07/25 12:37:43 INFO tool.BaseSqoopTool: Using Hive-specific
delimiters for output. You can override
11/07/25 12:37:43 INFO tool.BaseSqoopTool: delimiters with --fields-
terminated-by, etc.
11/07/25 12:37:43 DEBUG util.ClassLoaderStack: Checking for existing
class: com.quest.oraoop.OraOopManagerFactory
11/07/25 12:37:43 DEBUG util.ClassLoaderStack: Class is already
available. Skipping jar /usr/lib/sqoop/lib/oraoop-1.3.0.81.jar
11/07/25 12:37:43 DEBUG sqoop.ConnFactory: Added factory
com.quest.oraoop.OraOopManagerFactory in jar /usr/lib/sqoop/lib/
oraoop-1.3.0.81.jar specified by

/usr/lib/sqoop/conf/managers.d/oraoop
11/07/25 12:37:43 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.quest.oraoop.OraOopManagerFactory
11/07/25 12:37:43 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
11/07/25 12:37:43 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
com.quest.oraoop.OraOopManagerFactory
11/07/25 12:37:43 DEBUG oraoop.OraOopUtilities: Enabled OraOop debug
logging.
11/07/25 12:37:43 DEBUG oraoop.OraOopManagerFactory: Quest® Data
Connector for Oracle and Hadoop can be called by Sqoop!
11/07/25 12:37:43 INFO oraoop.OraOopManagerFactory: Quest® Data
Connector for Oracle and Hadoop is disabled.
11/07/25 12:37:43 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
com.cloudera.sqoop.manager.DefaultManagerFactory
11/07/25 12:37:43 DEBUG sqoop.ConnFactory: Instantiated ConnManager
com.cloudera.sqoop.manager.GenericJdbcManager@851052d
11/07/25 12:37:43 INFO tool.CodeGenTool: Beginning code generation
11/07/25 12:37:44 INFO manager.SqlManager: Executing SQL statement:
SELECT t.* FROM ENGINE_RAW_OUTPUT AS t WHERE 1=0
11/07/25 12:37:44 ERROR manager.SqlManager: Error executing statement:
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
ended

11/07/25 12:37:44 INFO manager.SqlManager: Executing SQL statement:
SELECT t.* FROM ENGINE_RAW_OUTPUT AS t WHERE 1=0
11/07/25 12:37:44 ERROR manager.SqlManager: Error executing statement:
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
ended

java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
ended

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:
207)
        at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:
863)
        at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:
1153)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:
1275)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:
3576)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:
3620)
        at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:
1491)
        at
com.cloudera.sqoop.manager.SqlManager.execute(SqlManager.java:442)
        at
com.cloudera.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:
112)
        at
com.cloudera.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:
96)
        at
com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:924)
        at
com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
        at
com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)
11/07/25 12:37:44 ERROR sqoop.Sqoop: Got exception running Sqoop:
java.lang.NullPointerException
java.lang.NullPointerException
        at
com.cloudera.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:889)
        at
com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:951)
        at
com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
        at
com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)

-- 
NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of Apache Sqoop mailing
list sqoop-user@incubator.apache.org. Please subscribe to it by sending an email to incubator-sqoop-user-subscribe@apache.org.
Mime
View raw message