sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arvind Prabhakar (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (SQOOP-304) Import from Oracle fails with ORA-00933 error.
Date Mon, 15 Aug 2011 22:17:27 GMT

     [ 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

        

Mime
View raw message