https://community.cloudera.com/t5/Support-Questions/Sqoop-split-by-on-a-string-varchar-column/m-p/165530#M127892 <P>The answer is outdated. It is possible to use a character attribute as split-by attribute.</P><P>You only need to add -Dorg.apache.sqoop.splitter.allow_text_splitter=true</P><P>after your 'sqoop job' statement like this:</P><PRE>sqoop job -Dorg.apache.sqoop.splitter.allow_text_splitter=true \\ --create ${JOB_NAME} \\ -- \\ import \\ --connect \"${JDBC}\" \\ --username ${SOURCE_USR} \\ --password-file ${PWD_FILE_PATH} \\</PRE><P>no guarantees though that sqoop splits your records evenly over your mappers though.</P> Thu, 03 Nov 2016 20:10:30 GMT rene_sluiter 2016-11-03T20:10:30Z