https://community.cloudera.com/t5/Support-Questions/Sqoop-Import-split-by-with-sql-function/m-p/188935#M151028 <P>Hi <A rel="user" href="https://community.cloudera.com/users/86184/elangovankrishna.html" nodeid="86184">@Krish E</A>! <BR />Sorry, I miss that <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> <BR />And have you tried to run without the cast? This parameter should allow you to run split-by with a varchar column.<BR />Another thing that's intriguing me, I assume that this Sqoop Job worked in the past right? <BR />If so, could check on the DB side if it's possible to run the following query? (Perhaps find an uncast exception)<BR /></P><PRE>select cast(order_number as UNSIGNED) from archive_orders;</PRE><P>I'm not sure if the error is in the sqoop side, cause I took a look at the sqoop github and didn't found any exception related to Unknown Column, so my guess would be that probably the JDBC got the error from MySQL and throw to Sqoop.</P><P><BR />Hope this helps!</P> Mon, 09 Jul 2018 10:24:06 GMT vmurakami 2018-07-09T10:24:06Z