[
https://issues.apache.org/jira/browse/SQOOP-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15386883#comment-15386883
]
Jean Luo commented on SQOOP-2676:
---------------------------------
I encountered a similar issue when using Sqoop to import data from Oracle DB.
The split-by column causing the issue was VARCHAR2.
Environment:
Hadoop 2.7.1.2.3.4.29-2
Sqoop 1.4.6.2.3.4.29-1
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

> Records are skipped when split-by columns contains NULL values
> --------------------------------------------------------------
>
> Key: SQOOP-2676
> URL: https://issues.apache.org/jira/browse/SQOOP-2676
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.4.5
> Environment: Hortonworks: HDP 2.2.4.2
> SQOOP: 1.4.5
> MS SQL: R2008
> Reporter: Dhaval Modi
> Labels: import, null, split-by, sqoop
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
