Hi,
Are you using HDP provided taradata sqoop connector or Teradata hadoop connector?
Here are jars and sample script if you download the sqoop jars from Teradata Web Site.
please execute below command after providing teradata IP, User ID, Password
sqoop import \
--connect jdbc:teradata://teradataIP/DATABASE=hadoop,CHARSET=UTF8 \
--driver "com.teradata.jdbc.TeraDriver" \
--username abc \
--password ****** \
--query "select * from abc where \$CONDITIONS" \
--null-string '\\N' \
--null-non-string '\\N' \
--hive-delims-replacement '\0D' \
--fields-terminated-by '\001' \
--target-dir /abc/ \
--m 1;
Check the Teradata Sqoop jars at below installed location:
/usr/hdp/2.3.4.0-3485/sqoop/lib/
tdgssconfig.jar
teradata-connector-1.3.2-hadoop210.jar
terajdbc4.jar
sqljdbc4.jar
Note: I downloaded the jars from Teradata Web Site.
try this and let me know.
Diff between HDP sqoop jars & Teradata sqoop jars.
Based on my observation:
HDP Teradata sqoop jars: User ID which you are using in sqoop should have read & write access on Teradata DB, HDP jars will create temporary table in Teradata before moving the data to HDFS
Teradata sqoop jars: Sqoop user ID should have Only read access and write access is not required. Teradata jars wouldn't create any temp tables in Teradata and directly moves the data to HDFS.
