[ https://issues.apache.org/jira/browse/SQOOP-3138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15880820#comment-15880820 ]
Hudson commented on SQOOP-3138: ------------------------------- SUCCESS: Integrated in Jenkins build Sqoop-hadoop20 #1090 (See [https://builds.apache.org/job/Sqoop-hadoop20/1090/]) SQOOP-3138: Netezza Direct Import does not support --columns options (venkat: [https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=d8c4b3ccdd06c5e300e4552b962e97c714651797]) * (edit) src/java/org/apache/sqoop/mapreduce/db/netezza/NetezzaExternalTableImportMapper.java > 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)