2.10 - Oracle Data Type Mapping - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Teradata QueryGrid
September 2019
User Guide

Global Types to Oracle Data Types

The initiator connector maps global data types to Oracle data types.

Global Data Type Oracle 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_Latin / G_Char_UTF16 Char (Character Set Latin / Unicode)
G_Clob_UTF16 / G_Clob_Latin Clob
G_Date Date
G_Decimal Decimal
G_Double Double precision
G_Float Float
G_Integer Integer
G_IntervalDayToSecond Interval day to second
G_IntervalYearToMonth Interval year to month
G_JSON_UTF16 / G_JSON NVarchar2
G_Number Number
G_SmallInt Smallint
G_Time Time
G_Timestamp Timestamp
G_TimestampWithTimeZone Timestamp with time zone
G_TimeWithTimeZone Time with time zone
G_Varbyte Long raw
G_Varchar_Latin Varchar (Character Set Latin)
G_Varchar_UTF16 NVarchar2 (Character Set Unicode)
G_XML NVarchar2
Others Varchar2

Oracle Data Types to Global Types

The target connector maps Oracle data types to global data types.

Oracle Data Type Global Data Type
Binary_Double G_Double
Binary_Float G_Float
Blob G_Blob
Char G_Char_UTF16 / G_Char_Latin (based on charset)
Clob G_Clob_UTF16
Date G_Timestamp
IntervalDS G_IntervalDayToSecond
IntervalYM G_IntervalYearToMonth
Long G_Clob_UTF16
Long raw G_Blob
NChar G_Char_UTF16
NClob G_Clob_UTF16
Number / Float G_Number
NVarchar G_Varchar_UTF16
RAW G_Byte
Timestamp G_TimeStamp
Timestamp with local time zone G_TimeStamp
Timestamp with time zone G_TimestampWithTimeZone
Varchar2 / Varchar G_Varchar_UTF16 / G_Varchar_Latin (based on charset)
Varray G_Array
User must have access to SELECT_CATALOG_ROLE.
Others Currently not supported

Oracle Varchar and Binary Types Considerations

Oracle connector BLOB columns are restricted to a maximum 2GB and CLOB columns are restricted a maximum 1GB in size. However, due to the in-memory nature of these types, a large amount of resources are required on the Oracle side when their sizes near 1GB. Therefore, Teradata recommends increasing the Oracle connector driver heap size when working with CLOB or BLOB types.