Teradata Datatype Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

Teradata Datatype Mapping

  • Dark
    Light
  • PDF

We match Teradata data types to Rivery data types while extracting your data. If a data type is not supported, we will map it as a String type.

The following table shows the mapping of Teradata data types to Rivery-compatible types:

Teradata Type Rivery Type
INTEGER INTEGER
SMALLINT INTEGER
BIGINT INTEGER
BOOLEAN boolean
DECIMAL FLOAT
BYTEINT INTEGER
BYTE STRING
VARBYTE STRING
BLOB STRING
FLOAT FLOAT
NUMBER FLOAT
DATE DATE
TIME TIME
TIMESTAMP TIMESTAMP
INTERVAL_YEAR INTEGER
INTERVAL_YEAR_TO_MONTH STRING
INTERVAL_MONTH INTEGER
INTERVAL_DAY INTEGER
INTERVAL_DAY_TO_HOUR STRING
INTERVAL_DAY_TO_MINUTE STRING
INTERVAL_DAY_TO_SECOND STRING
INTERVAL_HOUR INTEGER
INTERVAL_HOUR_TO_MINUTE STRING
INTERVAL_HOUR_TO_SECOND STRING
INTERVAL_MINUTE INTEGER
INTERVAL_MINUTE_TO_SECOND STRING
INTERVAL_SECOND FLOAT
PERIOD_DATE STRING
PERIOD_TIME STRING
PERIOD_TIMESTAMP STRING
CHAR STRING
VARCHAR STRING
CLOB STRING
XML STRING
JSON STRING
TDUDT STRING
GEOMETRY STRING
MBR STRING
MBB STRING

Was this article helpful?