All Forums Tools
Cvinodh 32 posts Joined 10/11
30 Aug 2016
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"

You must sign in to leave a comment.