All Forums Extensibility
ranjan.kumar1 3 posts Joined 08/11
22 Aug 2011
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.LocalStatementParame ters.buildBatchStatement(LocalStatementParameters.java :112)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedSta tement.executeBatch(TeraLocalPreparedStatement.java: 298)
at org.apache.hadoop.mapreduce.lib.db.DBOutputFormat$DBRe cordWriter.close(DBOutputFormat.java:89)
at org.apache.hadoop.mapred.lib.db.DBOutputFormat$DBRecor dWriter.close(DBOutputFormat.java:57)
at org.apache.hadoop.mapred.MapTask$DirectMapOutputCollec tor.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(U serGroupInformation.java:1115)
at org.apache.hadoop.mapred.Child.main(Child.java:262)

Any idea what could be wrong?
Thanks

tomnolan 594 posts Joined 01/08
23 Aug 2011

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

You must sign in to leave a comment.