Supported Data Types - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
gzn1554761068186.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantageā„¢

Vantage supports shredding to columns of the following data types.

CHAR VARCHAR CHARACTER(n) CHARACTER SET GRAPHIC
VARCHAR(n) CHARACTER SET GRAPHIC CLOB BYTE
VARBYTE BLOB BYTEINT
SMALLINT INTEGER BIGINT
FLOAT (for data types where applicable, precision is supported) DECIMAL NUMBER
DATE TIME TIME WITH TIME ZONE
TIMESTAMP TIMESTAMP WITH TIME ZONE INTERVAL YEAR
INTERVAL YEAR TO MONTH INTERVAL MONTH INTERVAL DAY
INTERVAL DAY TO HOUR INTERVAL DAY TO MINUTE INTERVAL DAY TO SECOND
INTERVAL HOUR INTERVAL HOUR TO MINUTE INTERVAL HOUR TO SECOND
INTERVAL MINUTE INTERVAL MINUTE TO SECOND INTERVAL SECOND
PERIOD (DATE) PERIOD (TIME) PERIOD (TIME WITH TIME ZONE)
PERIOD (TIMESTAMP) PERIOD (TIMESTAMP WITH TIME ZONE) XML
JSON