@Kit Menke I've tried importing from hdfs to hive using 'load data inpath' or just create an external table, both work well and could be queried with no issues. Below is the code, do you see any problems? Thanks! sqoop import \ -libjars ${lib_jars} \ -D mapreduce.job.queuename=default \ -verbose \ --connect jdbc:teradata://td/DATABASE=$1 \ --connection-manager org.apache.sqoop.teradata.TeradataConnManager \ --username user \ --password pw \ --table $2 \ --hive-import \ --hive-overwrite \ --hive-table $1.$2 \ ... View more

Hi Kit, Very useful tips!! However I've encountered some problems when using the second way to pull my Teradata table into hive. The first step 'create hive table' successfully created a table in hive with correct schema while the second step failed and got an error message "Can not create a path from an empty string.". Do you have any idea on this? p.s. I've also used the same configuration to import the table into hdfs which succeeded and the only change I made is "--hive-import --hive-table hivetablename". Thank you! ... View more