TDCH Export from HDFS timestamp issue.

Tools
Enthusiast

TDCH Export from HDFS timestamp issue.

I am loading a file from HDFS into Teradata using Teradata Hadoop connector. All my records are getting rejected due to error code 6760 (invalid timestamp). All the timestamp fields are of format yyyy-MM-dd HH:mm:ss.S with sample values being 2015-05-06 10:55:16.0, 2015-08-14 04:45:33.0.  I am setting both targettimestampformat and sourcetimestampformat arguments in my job submission as shown below but still my job fails. so my questions are

1) what can be done to resolve the issue

2) should I have to use both targettimestampformat and sourcetimestampformat property or should I use either one of it.

Arguments  passed to the TDCH cmd line application.

-targettimestampformat "yyyy-MM-dd HH:mm:ss.S" -sourcetimestampformat "yyyy-MM-dd HH:mm:ss.S"

Thanks,

Charles

Tags (2)