[
https://issues.apache.org/jira/browse/SQOOP-3156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15933264#comment-15933264
]
Shane Mathews commented on SQOOP-3156:
--------------------------------------
I've temporarily worked around this issue by creating a view on my postgresql
and querying that instead of using the --where and --columns params
> PostgreSQL direct connector is ignoring --columns
> -------------------------------------------------
>
> Key: SQOOP-3156
> URL: https://issues.apache.org/jira/browse/SQOOP-3156
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.4.6
> Reporter: Shane Mathews
> Priority: Minor
>
> DirectPostgresqlManager seems to directly query the columns of the table and
> use those instead of using the passed in --columns
> can be reproduced using something like this:
> sqoop import --connect jdbc:postgresql://foo.com/chdbauthors --username
> foouser --password foopassword --hive-import --direct --table footable
> --columns "col1,col2,col3" --where "col1 is not null " --direct-split-size
> 268435456 --hive-table foohive_table
> if that table has more columns than col1, col2, and col3, those will also be
> queried
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
