sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arvind Prabhakar <arv...@apache.org>
Subject Re: Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command not properlyended error
Date Mon, 25 Jul 2011 20:08:27 GMT
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,  <bejoyks@gmail.com> wrote:
> 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