2.06 - Spark SQL 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 Spark SQL 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 Spark SQL 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.
string
G_Char_UTF16 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 string
G_Date date
G_Decimal decimal
G_Double double
G_Float float
G_Integer integer
G_JSON_UTF16 / G_JSON_Latin * string
G_Map map
G_Number decimal
G_Row struct
G_SmallInt smallint
G_STGeometry * string
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.
string
G_Varchar_UTF16 string
G_XML * string
Others Currently not supported

Spark SQL Data Types to Global Types

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