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 16.20 Feature Update 1 and later.
Vector types denoted with a double asterisk (**) are available with Teradata 20.00.27.19.
Vector types denoted with a triple asterisk (***) are available with Teradata 20.00.28.60.
| 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_Vector | Vector** |
| G_Vector32 | Vector32*** |
| 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 16.20 Feature Update 1 and later.
Vector types denoted with a double asterisk (**) are available with Teradata 20.00.27.19.
Vector types denoted with a triple asterisk (***) are available with Teradata 20.00.28.60.
| 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 |
| Vector** | G_Vector |
| Vector32*** | G_Vector32 |
| XML * | G_XML |
| Others | Currently not supported |