All Forums Extensibility
sourabhpotnis 3 posts Joined 01/14
27 Jan 2014
Teradata connector for Hadoop 2.06

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:

14/01/27 07:43:26 ERROR tool.TeradataExportTool: java.lang.IncompatibleClassChangeError: Found interface org.apache.hadoop.mapreduce.JobContext, but class was expected

        at com.teradata.hadoop.mapreduce.TeradataOutputFormat.che ckOutputSpecs(

        at org.apache.hadoop.mapreduce.JobSubmitter.checkSpecs(Jo

        at org.apache.hadoop.mapreduce.JobSubmitter.submitJobInte rnal(

        at org.apache.hadoop.mapreduce.Job$

        at org.apache.hadoop.mapreduce.Job$

        at Method)



        at org.apache.hadoop.mapreduce.Job.submit(

        at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job. java:1286)

        at com.teradata.hadoop.mapreduce.TeradataOutputProcessor. run(

        at com.teradata.hadoop.mapreduce.TeradataBatchInsertOutpu :66)

        at com.teradata.hadoop.job.TeradataExportJob.runJob(Terad

        at com.teradata.hadoop.tool.TeradataJobRunner.runExportJo b(


        at 70)

        at 84)

        at com.teradata.hadoop.tool.TeradataExportTool.main(Terad


14/01/27 07:43:26 INFO tool.TeradataExportTool: job completed with exit code 10000





hadoop com.teradata.hadoop.tool.TeradataExportTool -url jdbc:teradata://server_name/database=DB_TAB  -username user-password pwd -jobtype hdfs -sourcepaths /user/example2_hdfs/01 -nummappers 1 -separator ',' -targettable test1



Is connector available for Hadoop 2.06? Which version and download link?



Mark_tdch 1 post Joined 06/13
27 Jan 2014

HDP2.0 is supported on TDCH1.1+. The following is the download link.

sourabhpotnis 3 posts Joined 01/14
31 Jan 2014

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 :

Error: com.teradata.hadoop.exception.TeradataHadoopSQLException: java.sql.BatchUpdateException: [Teradata JDBC Driver] [TeraJDBC] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.

        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeBatchUpdateException(

        at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeBatchUpdateException(


while its running fine with multiple.fastload.


Command: hadoop com.teradata.hadoop.tool.TeradataExportTool -url jdbc:teradata://Server/database=DB_TAB  -username user -password hadoop -jobtype hdfs  -sourcepaths /user/example2_hdfs/TDCSVsample -nummappers 1 -separator ',' -targettable test1


Tried with different number of mappers 1/2/10, but getting same error.


Any thoughts?



amala 1 post Joined 02/10
14 Feb 2014

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?
export USERLIBTDCH=/usr/lib/sqoop/teradata-connector-1.1.1-hadoop200.jar
hadoop jar $USERLIBTDCH com.teradata.hadoop.tool.TeradataImportTool -classname com.teradata.jdbc.TeraDriver -url jdbc:teradata:// ROOT -password XXXX -jobtype hdfs -fileformat textfile -method -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] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

You must sign in to leave a comment.