You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Khamgaonwala, Hussain" <Hu...@supervalu.com> on 2012/06/01 04:59:32 UTC

Sqoop Teradata issue

Hello,

 

Has anyone seen this error message below while exporting data to
Teradata using Sqoop?

 

java.io.IOException: java.sql.BatchUpdateException: [Teradata JDBC
Driver] [TeraJDBC 13.10.00.31] [Error 1154] [SQLState HY000] A failure
occurred while inserting the batch of rows destined for database table
"workspacebigdata"."upc_frequency_segment_temp_0". Details of the
failure can be found in the exception chain that is accessible with
getNextException.

        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataR
ecordWriter.java:133)

        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataR
ecordWriter.java:27)

        at
org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.
java:531)

        at
org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutput
Context.java:80)

        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:
82)

        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:
40)

        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)

        at
com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressM

 

 

I have tried with the latest Teradata jdbc jars  and it too gives the
same error . 

 

 

Regards,

Hussain K