[SQOOP-2676] Records are skipped when split-by columns contains NULL values

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.5
• Labels: import null split-by sqoop

Environment

Hortonworks: HDP 2.2.4.2
SQOOP: 1.4.5
MS SQL: R2008

• Assignee: Unassigned
• Reporter: Dhaval Modi
• Created: 09/Nov/15 14:12
• Updated: 21/Jul/16 00:20

Description

Hi Team,

This issue occurs when the integral column having NULL value is used in split-by attribute.

For e.g.
Col1
1
2
NULL
3
4

In above example, count of rows is 5, but actually only 4 rows are imported.