[
https://issues.apache.org/jira/browse/SQOOP-597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13452954#comment-13452954
]
Jarek Jarcec Cecho commented on SQOOP-597:
------------------------------------------
There is small "hack" for bypassing this issue. User might specify following
parameter on the command line:
{code}
--table 'schema"."table'
{code}
The entire table name is enclosed in single quotes to prevent the shell from
any other escape resolution as there are two double quotes inside. Sqoop should
escape this term correctly to "schema"."table" - single quotes will be removed
by the shell and double quotes will be added around the entire expression by
Sqoop.
> PostgreSQL Manager is incorrectly escaping table names
> ------------------------------------------------------
>
> Key: SQOOP-597
> URL: https://issues.apache.org/jira/browse/SQOOP-597
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.4.2
> Reporter: Jarek Jarcec Cecho
> Assignee: Jarek Jarcec Cecho
> Fix For: 1.4.3
>
>
> PostgreSQL Manager is incorrectly escaping entire table name argument into
> double quotes like on following example:
> {code}
> schema.table => "schema.table"
> {code}
> However this escaping is not valid as it should be one of following
> possibilities:
> {code}
> schema.table => schema."table"
> schema.table => "schema"."table"
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
