[SQOOP-304] Import from Oracle fails with ORA-00933 error.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.3.0
• Component/s: connectors/oracle
• Assignee: Arvind Prabhakar
• Reporter: Arvind Prabhakar
• Created: 28/Jul/11 01:43
• Updated: 15/Aug/11 22:16
• Resolved: 15/Aug/11 22:16

Description

The Sqoop generated metadata query for Oracle connector is as follows:

SELECT t.* FROM ENGINE_RAW_OUTPUT AS t WHERE 1=0

This query fails with error ORA-00933 due to the use of AS keyword.