You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Suraj Nayak (JIRA)" <ji...@apache.org> on 2017/02/21 00:42:44 UTC
[jira] [Created] (SQOOP-3138) Netezza Direct Import does not
support --columns options
Suraj Nayak created SQOOP-3138:
----------------------------------
Summary: Netezza Direct Import does not support --columns options
Key: SQOOP-3138
URL: https://issues.apache.org/jira/browse/SQOOP-3138
Project: Sqoop
Issue Type: Bug
Components: connectors
Affects Versions: 1.4.6
Reporter: Suraj Nayak
Priority: Minor
Netezza Direct import Mapper is not sensitive to --columns. The parameters passed to --columns C1,C2,C3,C4 are ignored by {{NetezzaExternalTableImportMapper}}.
(NetezzaExternalTableImportMapper)[https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/mapreduce/db/netezza/NetezzaExternalTableImportMapper.java#L83] on line 83 is based of (output field names)[https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/mapreduce/db/DBConfiguration.java#L420] instead of input field names.
Even when -D mapreduce.jdbc.output.field.names=C1,C2,C3,C4 is set, another bug in (NetezzaExternalTableImportMapper @ line 128 ) [https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/mapreduce/db/netezza/NetezzaExternalTableImportMapper.java#L128] duplicates the first column. This is due to the for loop initialization bug where variable {{i}} should be initialized to {{1}} instead of {{0}}.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)