[ https://issues.apache.org/jira/browse/SQOOP-3138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15883693#comment-15883693 ]
Suraj Nayak commented on SQOOP-3138: ------------------------------------ Thanks [~BoglarkaEgyed] and [~venkatnrangan] > 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 > Assignee: Suraj Nayak > Priority: Minor > Fix For: 1.4.7 > > Attachments: SQOOP-3138.patch > > > Netezza Direct import Mapper is not sensitive to {{columns}} option. 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)