How to efficiently write the query to export the data faster without failing the query?

I am using a query like
sqoop export --connect jdbc:teradata://server/database=Mydata --username abc
--password xxxx
-Dsqoop.export.records.per.statement=1000
--batch
--hive-table customer
--table CUSTOMER
--input-null-non-string '\N' \ --input-null-string '\N'
This query is working fine for 10 million records. Takes 45 minute to load the data to TeraData table. For 1000 million records to export the data to Teradata empty table it may take more time to complete the export.
How do i efficiently write the query to export the data faster without failing the query?

Tagged:
Sign In or Register to comment.