2.10 - Teradata Data Type Mapping - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K

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 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