Duplicate records found when split-by column is of type char(n)

Hi,

While working with SQOOP, we found an issue where records are duplicated while importing the data. This is seen when split-by column is of type char.

We understand, ideally, integral columns with not null type must be chosen for split-by column, but in our case, all integral columns has null values. There is open bug (SQOOP - 2536) raised for this issue.

But as sqoop have support for char datatype to be used in split-by column, and it giving unexpected results. Thus raising this bug.