Global Types to Teradata Data Types
The initiator connector maps global data types to Teradata data types.
Teradata data types denoted with an asterisk (*) are only available with Teradata Database 16.20 Feature Update 1 and later.
Global Data Type | Teradata Data Type |
---|---|
G_Array | Varchar (Character Set Unicode) |
G_Array_VC_UTF16 / G_Array_VC_Latin | Array * |
G_Bigint | Bigint |
G_Blob | Blob |
G_Boolean | Byteint |
G_Byte | Byte |
G_ByteInt | Byteint |
G_Char_Kanji1 | Char (Character Set Kanji1) |
G_Char_KanjiSJIS | Char (Character Set KanjiSJIS) |
G_Char_Latin | Char (Character Set Latin) |
G_Char_UTF8 | Char (Character Set Unicode) |
G_Char_UTF16 | Char (Character Set Unicode) |
G_Clob_UTF16 / G_Clob_Latin | Clob |
G_DatasetAvro | Dataset storage format Avro * |
G_Date | Date |
G_Decimal / G_BigDecimal | Decimal |
G_Double | Double precision |
G_Float | Float |
G_Integer | Integer |
G_IntervalDay | Interval day |
G_IntervalDayToHour | Interval day to hour |
G_IntervalDayToMinute | Interval day to minute |
G_IntervalDayToSecond | Interval day to second |
G_IntervalHour | Interval hour |
G_IntervalHourToMinute | Interval hour to minute |
G_IntervalHourToSecond | Interval hour to second |
G_IntervalMinute | Interval minute |
G_IntervalMinuteToSecond | Interval minute to second |
G_IntervalMonth | Interval month |
G_IntervalSecond | Interval second |
G_IntervalYear | Interval year |
G_IntervalYearToMonth | Interval year to month |
G_JSON_UTF16 / G_JSON_Latin | JSON * |
G_Map | Varchar (Character Set Unicode) |
G_MBB | MBB * |
G_MBR | MBR * |
G_Number | Number |
G_Period | Period * |
G_Row | Varchar (Character Set Unicode) |
G_SmallInt | Smallint |
G_STGeometry | ST_Geometry * |
G_Time | Time |
G_TimeWithTimeZone | Time with time zone |
G_Timestamp | Timestamp |
G_TimestampWithTimeZone | Timestamp with time zone |
G_UDT_UTF16 / G_UDT_Latin | Distinct UDT / Structured UDT * |
G_Varbyte | Varbyte |
G_Varchar_Kanji1 | Varchar (Character Set Kanji1) |
G_Varchar_KanjiSJIS | Varchar (Character Set KanjiSJIS) |
G_Varchar_Latin | Varchar (Character Set Latin) |
G_Varchar_UTF8 | Varchar (Character Set Unicode) |
G_Varchar_UTF16 | Varchar (Character Set Unicode) |
G_XML | XML * |
Others | Currently not supported |
Teradata Data Types to Global Types
The target connector maps Teradata data types to global data types.
Teradata data types denoted with an asterisk (*) are only available with Teradata Database 16.20 Feature Update 1 and later.
Teradata Data Type | Global Data Type |
---|---|
Array * | G_Array_VC_UTF16 / G_Array_VC_Latin |
Bigint | G_BigInt |
Blob | G_Blob |
Byte | G_Byte |
Byteint | G_Byteint |
Char | G_Char_UTF16 / G_Char_Latin / G_Char_Kanji1 / G_Char_KanjiSJIS |
Clob | G_Clob_UTF16/Latin |
Dataset storage format Avro * | G_DatasetAvro |
Date | G_Date |
Decimal | G_Decimal |
Distinct UDT/Structured UDT * | G_UDT / G_UDT_UTF16 / G_UDT_Latin |
Double precision | G_Double |
Float | G_Float |
Integer | G_Integer |
Interval day | G_IntervalDay |
Interval day to hour | G_IntervalDayToHour |
Interval day to minute | G_IntervalDayToMinute |
Interval day to second | G_IntervalDayToSecond |
Interval hour | G_IntervalHour |
Interval hour to minute | G_IntervalHourToMinute |
Interval hour to second | G_IntervalHourToSecond |
Interval minute | G_IntervalMinute |
Interval minute to second | G_IntervalMinuteToSecond |
Interval month | G_IntervalMonth |
Interval second | G_IntervalSecond |
JSON * | G_JSON_UTF16 / G_JSON_Latin |
MBB * | G_MBB |
MBR * | G_MBR |
Number | G_Number |
Period (all period types) * | G_Period |
Smallint | G_SmallInt |
ST_Geometry * | G_STGeometry |
Timestamp | G_TimeStamp |
Timestamp with time zone | G_TimestampWithTimeZone |
Varbyte | G_Varbyte |
Varchar | G_Varchar_UTF16 / G_Varchar_Latin / G_Varchar_Kanji1 / G_Varchar_KanjiSJIS |
XML * | G_XML |
Others | Currently not supported |