Sqoop – Data import & export
Data import using Sqoop
Teradata example
$ sqoop import --connect jdbc:teradata://server_name/DATABASE=db1,LOGMECH=LDAP,CHARSET=UTF8 --driver "com.teradata.jdbc.TeraDriver" --username <user1> --password <password1> --query "select a.*, b.* from a inner join b on a.a_id=b.a_id where \$CONDITIONS AND a.f1 in ('A','B','C') group by 1" --null-string '\\N' --null-non-string '\\N' --hive-delims-replacement '\0D' --fields-terminated-by '\001' --target-dir /tmp/datadir/dataset1/tdimport --m 1
HTH
