[jira] [Updated] (SQOOP-3156) PostgreSQL direct connector is ignoring --columns

["Shane Mathews (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SQOOP-3156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shane Mathews updated SQOOP-3156:
---------------------------------
    Description: 
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/chdbfoo --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

  was:
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


> 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/chdbfoo --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)