You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Arvind Prabhakar (JIRA)" <ji...@apache.org> on 2011/07/28 03:45:10 UTC
[jira] [Created] (SQOOP-304) Import from Oracle fails with
ORA-00933 error.
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
[jira] [Resolved] (SQOOP-304) Import from Oracle fails with
ORA-00933 error.
Posted by "Arvind Prabhakar (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Updated] (SQOOP-304) Import from Oracle fails with
ORA-00933 error.
Posted by "Arvind Prabhakar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arvind Prabhakar updated SQOOP-304:
-----------------------------------
Attachment: sample-output.txt
> 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