Bejoy, In the import statement, are you providing the table name using a schema qualifier prefix (schema.table)? If so, that could be the problem. See SQOOP-222 [1] for details. If this indeed is the issue you are running into, a work-around would be to change the table name to a simple table name and use the username/password of the account that owns the schema.
If doing the above does not fix the problem, please provide more details about the version of Sqoop, and the complete command you issued (with masked password). [1] https://issues.cloudera.org/browse/SQOOP-222 Thanks, Arvind On Mon, Jul 25, 2011 at 10:16 AM, <[email protected]> wrote: > Redirecting the message to new apache sqoop mailing list > Regards > Bejoy K S > > -----Original Message----- > From: reju <[email protected]> > Date: Mon, 25 Jul 2011 09:41:29 > To: Sqoop Users<[email protected]> > Reply-To: [email protected] > 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 [email protected] is deprecated in favor of > Apache Sqoop mailing list [email protected]. Please subscribe > to it by sending an email to [email protected]. >
