https://community.cloudera.com/t5/Support-Questions/sqoop-import-writes-NULL-when-reading-Null-values-from/m-p/207378#M169339 <P>Hi Dennis,</P><P>Even though I declared --null-string as --null-string '\\N' in the sqoop import synatax. still i am seeing "null" string value for all string fields where value is null in source schma. can you please provide any solution to it.</P><P>below is my sqoop import syntax.</P><P>import -Dhadoop.security.credential.provider.path=${jceks_loc} --password-alias ${passwordAlias} --username ${userName} --connect ${connection} --table ${sourceSchema}.${sourceTable} --hive-import --hive-table ${hiveTable} --target-dir ${hdfsDir} --fields-terminated-by "|" --delete-target-dir --null-string '\\N' -m 1</P><P>Thanks,</P><P>Brahma </P> Mon, 10 Jul 2017 23:20:39 GMT bramhanaelem 2017-07-10T23:20:39Z