[
https://issues.apache.org/jira/browse/SQOOP-1563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15045276#comment-15045276
]
Lan Jiang commented on SQOOP-1563:
----------------------------------
Run into the same issue. We also have a problem working with PostgreSQL. I made
the RDBMS table name to be upper case when exporting to Oracle so that it would
work. But later I have to switch to PostgreSQL and run into a similar problem.
In PostgreSQL, it has same table name as Oracle but using lower case. The SQL
created in the log has a double quote around the table name, essentially making
it case sensitive. Should be a simple fix by removing the double quote.
> When using Sqoop export command connecting to Oracle DB, the table name is
> case sensitive.
> ------------------------------------------------------------------------------------------
>
> Key: SQOOP-1563
> URL: https://issues.apache.org/jira/browse/SQOOP-1563
> Project: Sqoop
> Issue Type: Improvement
> Components: sqoop2-api
> Affects Versions: 1.4.4
> Reporter: Ramesh Mandalapu
> Priority: Minor
> Original Estimate: 10m
> Remaining Estimate: 10m
>
> When using Sqoop export command connecting to Oracle DB, the table name is
> case sensitive because the Oracle DB saves the metadata in uppercase. This
> should be made case-insensitive so no one needs to remember that the
> tablename must be typed in uppercase.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
