https://community.cloudera.com/t5/Support-Questions/Sqoop-Import-split-by-with-sql-function/m-p/188938#M151031 <P>No the Boundary query does work, but i figured that even though we do split by using a cast on a varchar column, once the split is identified sqoop internally does a sort of the column on split by which is a varchar according to Mysql and it brings in Duplicate on the target system.</P><P>I found unless you use a integer column or do an incremental load (after load to staging) will not solve the issues of duplicate on target with Varchar datatype with your split-by column</P> Tue, 10 Jul 2018 01:22:28 GMT elkrish 2018-07-10T01:22:28Z