Failure to insert in table

Extensibility

Failure to insert in table

I am trying to use JDBC connection to teradata from a map-reduce program (Hadoop). I am getting the following error stack trace.

11/08/22 10:57:33 INFO mapred.JobClient: Task Id : attempt_201107010928_0154_m_000001_2, Status : FAILED
java.lang.NullPointerException
at com.teradata.jdbc.jdbc_3.ifjdbc_4.LocalStatementParameters.buildBatchStatement(LocalStatementParameters.java:112)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.executeBatch(TeraLocalPreparedStatement.java:298)
at org.apache.hadoop.mapreduce.lib.db.DBOutputFormat$DBRecordWriter.close(DBOutputFormat.java:89)
at org.apache.hadoop.mapred.lib.db.DBOutputFormat$DBRecordWriter.close(DBOutputFormat.java:57)
at org.apache.hadoop.mapred.MapTask$DirectMapOutputCollector.close(MapTask.java:694)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:395)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:324)
at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1115)
at org.apache.hadoop.mapred.Child.main(Child.java:262)

Any idea what could be wrong?
Thanks
1 REPLY
Teradata Employee

Re: Failure to insert in table

It looks like you may have encountered a known problem with old versions of the Teradata JDBC Driver -- DR 143844 -- which is fixed in newer versions of the Teradata JDBC Driver.

We recommend that you upgrade to the newest version of the Teradata JDBC Driver available here on Developer Exchange.

http://downloads.teradata.com/download/connectivity/jdbc-driver