You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Gayathri Yeluru (JIRA)" <ji...@apache.org> on 2019/04/18 00:27:00 UTC

[jira] [Commented] (SQOOP-602) Unable to import data when table column has - in its name

    [ 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)