Data Type Mapping | Hive Connector | QueryGrid - Hive Data Type Mapping - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

Global Types to Hive Data Types

The initiator connector maps Hive data types to global.
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 target 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

Hive String and Binary Types Considerations

Hive String and Binary columns are restricted to a maximum 1GB in size. However, due to the in-memory nature of these types, a large amount of resources are required on the Hive side when their size nears the 1GB restriction. Therefore, caution is advised when inserting large Teradata CLOB or BLOB columns into the Hive String or Binary columns when using QueryGrid.