title: Sqoop import Null string
body: <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>