[SQOOP-3156] PostgreSQL direct connector is ignoring --columns

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.4.6
• Component/s: connectors/postgresql
• Assignee: Eric Lin
• Reporter: Shane Mathews
• Created: 20/Mar/17 18:37
• Updated: 07/May/17 11:46

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