HDFS to Teradata - example

Download connector http://hortonworks.com/hdp/addons/

**** Extract tar file ****

**** Copy jar into sqoop-client/lib ***

cp *.jar /usr/hdp/current/sqoop-client/lib/

**** Create tables in Teradata ****

We will be importing data from /tmp/test , HDFS location

**** Sqoop ****

sqoop export --connect jdbc:teradata://Terdatahost/Database=DBName --connection-manager org.apache.sqoop.teradata.TeradataConnManager --username user --password passwd --table test --export-dir /tmp/test/ --batch