Facing the datetime overflow issue in TPT script generation with timestamp(0) column

We are getting the error “Datetime field overflow” in Diyotta 4.x for most of the jobflows

Consider following example to analyze the issue-

we have column NFA_DATE_TS defined as timestamp(0).In Hive, the same column value is stored similar to Teradata timestamp(0) format (we defined derived attribute for this).

Now from Hive-> Teradata, in TFRM database, Diyotta is defining the column as timestamp(6) instead of timestamp(0) in working table and converting all hive values to timestamp(6) format.

As a result, in next step, while inserting timestamp(6) values to actual table timestamp(0) field, we are getting “Datetime field overflow” error.

Advanced User Asked on July 30, 2020 in Diyotta Monitor.
Add Comment
1 Answer(s)

Now we have fixed the datatime overflow issue in 4.1.0.3118.006  version

Now the TFORM table is getting created in the Hive database with timestamp(0)  in sync with the Teradata database.  Now the issue should be resolved and timestamp value should load properly into the Teradata table.

RE: Facing the datetime overflow issue in TPT script generation with timestamp(0) column

Expert Answered on July 30, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.