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

Teradata Datatype Mapping

  • Dark
    Light
  • PDF

Article summary

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 TypeRivery Type
INTEGERINTEGER
SMALLINTINTEGER
BIGINTINTEGER
BOOLEANboolean
DECIMALFLOAT
BYTEINTINTEGER
BYTESTRING
VARBYTESTRING
BLOBSTRING
FLOATFLOAT
NUMBERFLOAT
DATEDATE
TIMETIME
TIMESTAMPTIMESTAMP
INTERVAL_YEARINTEGER
INTERVAL_YEAR_TO_MONTHSTRING
INTERVAL_MONTHINTEGER
INTERVAL_DAYINTEGER
INTERVAL_DAY_TO_HOURSTRING
INTERVAL_DAY_TO_MINUTESTRING
INTERVAL_DAY_TO_SECONDSTRING
INTERVAL_HOURINTEGER
INTERVAL_HOUR_TO_MINUTESTRING
INTERVAL_HOUR_TO_SECONDSTRING
INTERVAL_MINUTEINTEGER
INTERVAL_MINUTE_TO_SECONDSTRING
INTERVAL_SECONDFLOAT
PERIOD_DATESTRING
PERIOD_TIMESTRING
PERIOD_TIMESTAMPSTRING
CHARSTRING
VARCHARSTRING
CLOBSTRING
XMLSTRING
JSONSTRING
TDUDTSTRING
GEOMETRYSTRING
MBRSTRING
MBBSTRING

Was this article helpful?

What's Next