Sqoop import Null string
<p>The <code>Null</code> values are displayed as '\N' when a hive external table is queried.</p>

<p>Below is the sqoop import script:</p>

<blockquote>
  <p>sqoop import -libjars /usr/lib/sqoop/lib/tdgssconfig.jar,/usr/lib/sqoop/lib/terajdbc4.jar -Dmapred.job.queue.name=xxxxxx \
  --connect jdbc:teradata://xxx.xx.xxx.xx/DATABASE=$db,LOGMECH=LDAP --connection-manager org.apache.sqoop.teradata.TeradataConnManager \
  --username $user --password $pwd --query "</p>
  
  <p>select col1,col2,col3 from $db.xxx </p>
  
  <p>where \$CONDITIONS" \
  --null-string '\N' --null-non-string '\N' \
  --fields-terminated-by '\t' --num-mappers 6 \
  --split-by job_number \
  --delete-target-dir \
  --target-dir $hdfs_loc</p>
</blockquote>

<p>Please advise what change should be done to the script so that nulls are displayed as nulls when the external hive table is queried.</p>