sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gayathri Yeluru (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-602) Unable to import data when table column has - in its name
Date Thu, 18 Apr 2019 00:27:00 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16820607#comment-16820607
] 

Gayathri Yeluru commented on SQOOP-602:
---------------------------------------

The work around for this bug (containing special character '-' ) is 

In free-form query - 

--query "SELECT \"test-id\",\"test-name\",\"test-country\" FROM PUB.testtable where \$CONDITIONS
"

In Split-by clause -

--split-by '""'test-id'""'

> Unable to import data when table column has - in its name
> ---------------------------------------------------------
>
>                 Key: SQOOP-602
>                 URL: https://issues.apache.org/jira/browse/SQOOP-602
>             Project: Sqoop
>          Issue Type: Bug
>            Reporter: Sudhakar Vankamamidi
>            Priority: Major
>
> unable to import a table with a column such as Customer-ID



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message