I am trying to export data from HDFS (HDP 2.06) into Teradata(version 13) using td-connector-for-hadoop-1.0.9a-hdp1.3-linux-x86-64-sqoop-integration-edition.
Its giving following error while exporting:
HDP2.0 is supported on TDCH1.1+. The following is the download link.
Thanks Mark_tdch for the answer.
TDCH1.1 connector is working with HDP 2.06.
But with batch.insert export I am getting following error :
This is my first time using Teradata Import Tool. I downloaded the jar file and put it in sqoop folder and tried to import a teradata table to hadoop as given below but I get "[SQLState 28000] The UserId, Password or Account is invalid" error eventhough everything I gave is correct and I'm able to login to SQL Assistant using the same credentials. Can anyone please advise how to fix this? Could it be something related to LDAP issue? How do I mention that this is LDAP in the command below?
hadoop jar $USERLIBTDCH com.teradata.hadoop.tool.TeradataImportTool -classname com.teradata.jdbc.TeraDriver -url jdbc:teradata://a.b.c.net/DATABASE=XYZ-username ROOT -password XXXX -jobtype hdfs -fileformat textfile -method split.by.hash -separator "," -sourcetable ICDW_REG_QRY -targetpaths /user/ABC/TD_REG_QRY
14/02/13 00:36:28 ERROR tool.TeradataImportTool: com.teradata.hadoop.exception.TeradataHadoopException: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.39] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.