[SQOOP-3138] Netezza Direct Import does not support --columns options

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.4.6
• Fix Version/s: 1.4.7
• Component/s: connectors
• Flags: Important
• Assignee: Suraj Nayak
• Reporter: Suraj Nayak
• Created: 21/Feb/17 00:42
• Updated: 24/Feb/17 22:57
• Resolved: 23/Feb/17 16:16

Description

Netezza Direct import Mapper is not sensitive to columns option. The parameters passed to --columns C1,C2,C3,C4 are ignored by NetezzaExternalTableImportMapper.

NetezzaExternalTableImportMapper on line 83 is based of output field names 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 duplicates the first column. This is due to the for loop initialization bug where variable i should be initialized to 1 instead of 0.

Issue Links

• links to: ReviewBoard