[
https://issues.apache.org/jira/browse/SQOOP-304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arvind Prabhakar resolved SQOOP-304.
------------------------------------
Resolution: Invalid
>From the console log:
{noformat}
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
{noformat}
It is evident that the connector being used is the Generic JDBC connector which
generates the query with "AS" keyword in it and hence the reported problem. If
the user does not specify an explicit driver, the built in Oracle connector
will be used which generates the query that does not include the "AS" keyword.
> Import from Oracle fails with ORA-00933 error.
> ----------------------------------------------
>
> Key: SQOOP-304
> URL: https://issues.apache.org/jira/browse/SQOOP-304
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/oracle
> Affects Versions: 1.3.0
> Reporter: Arvind Prabhakar
> Assignee: Arvind Prabhakar
> Attachments: sample-output.txt
>
>
> The Sqoop generated metadata query for Oracle connector is as follows:
> {code}
> SELECT t.* FROM ENGINE_RAW_OUTPUT AS t WHERE 1=0
> {code}
> This query fails with error {{ORA-00933}} due to the use of {{AS}} keyword.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
