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
|