https://community.cloudera.com/t5/Support-Questions/Sqoop-Import-split-by-with-sql-function/m-p/188932#M151025 <P>Hi <A rel="user" href="https://community.cloudera.com/users/86184/elangovankrishna.html" nodeid="86184">@Krish E</A> <BR />Have you tried to set this property on your sqoop command?<BR /></P><PRE>-Dorg.apache.sqoop.splitter.allow_text_splitter=true</PRE> Then, in this case, you won't need to cast the PK. <P>Ps: Not sure if this property works alongside with the others parameters passed, guess it's worth to test it first <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P><P>Hope this helps!</P> Sat, 07 Jul 2018 06:13:55 GMT vmurakami 2018-07-07T06:13:55Z