2.06 - Hive Data Type Mapping - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty

Global Types to Hive Data Types

The target connector maps Hive data types to global data types.
Global Data Types denoted with an asterisk (*) are only available with Teradata Database 16.20 Feature Update 1 and later.
Global Data Type Hive Data Type
G_Array Array
G_Array_VC_UTF16 / G_Array_VC_Latin * Array
G_BigInt Bigint
G_Blob Binary
G_Boolean Boolean
G_Byte Binary
G_ByteInt Tinyint
G_Char_Latin
Latin data type mapping is only for data types using ISO_8859_1 or US_ASCII encoding.
Char
G_Char_UTF16 Char
G_Clob_Latin
Latin data type mapping is only for data types using ISO_8859_1 or US_ASCII encoding.
String
G_Clob_UTF16 String
G_Date Date
G_Decimal Decimal
G_Double Double
G_Float Float
G_Integer Integer
G_JSON_UTF16 / G_JSON_Latin * String/Varchar
G_Map Map
G_Number Decimal
G_Row Struct
G_STGeometry * String/Varchar
G_SmallInt Smallint
G_TimeStamp Timestamp
G_Varbyte Binary
G_Varchar_Latin
Latin data type mapping is only for data types using ISO_8859_1 or US_ASCII encoding.
Varchar
G_Varchar_UTF16 Varchar
G_XML * String/Varchar
Others Currently not supported

Hive Data Types to Global Types

The remote connector maps Hive data types to global data types.

Hive Data Type Global Data Type
array G_Array
bigint G_BigInt
binary G_Blob
boolean G_Boolean
char G_Char_Latin
Latin data type mapping is only for data types using ISO_8859_1 or US_ASCII encoding.
char G_Char_UTF16
date G_Date
decimal G_Decimal
double G_Double
float G_Float
integer G_Integer
map G_Map
smallint G_SmallInt
string G_Clob_Latin
Latin data type mapping is only for data types using ISO_8859_1 or US_ASCII encoding.
string G_Clob_UTF16
struct G_Row
timestamp G_TimeStamp
tinyint G_ByteInt
varchar G_Varchar_Latin
Latin data type mapping is only for data types using ISO_8859_1 or US_ASCII encoding.
varchar G_Varchar_UTF16
Others Currently not supported