title: Sqoop export for 100 million records faster
body: <p>I have query similar to the below</p>
  
  <pre><code>sqoop export 
      --connect jdbc:teradata://server/database=BIGDATA 
      --username dbuser 
      --password dbpw 
      -Dsqoop.export.records.per.statement=500
      --batch 
      --hive-table country
      --table COUNTRY
      --input-null-non-string '\\N' \ --input-null-string '\\N'  
  </code></pre>
  
  <p>The above query is working fine for 3 million records(Takes 1 hour to load the data to TeraData table). For 100 million records to export the data to Teradata empty table i think it may take more time to complete the export.  How can i efficiently write the query to export the data faster without failing the query?</p>