Redirecting the message to new apache sqoop mailing list
Regards
Bejoy K S
-----Original Message-----
From: reju <rej...@gmail.com>
Date: Mon, 25 Jul 2011 09:41:29
To: Sqoop Users<sqoop-u...@cloudera.org>
Reply-To: sqoop-u...@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-u...@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-subscr...@apache.org.
