• Ask a Question
  • Create a Poll
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Advanced User

      RE: 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.

      Asked by JohnGS on July 30, 2020 in Diyotta Monitor.
      1 Answers
      Expert

      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

      Answered by Naveen Arza on July 30, 2020..