...
Teradata specific data types mapped to string and can have multiple input formats and one ‘canonical’ output form. Please, refer to To figure out proper formats, see Teradata data types documentation to figure out proper formats.
Teradata Data Type | CDAP Schema Data Type |
---|---|
BYTEINT | INT |
SMALLINT | INT |
INTEGER | INT |
BIGINT | LONG |
DECIMAL/NUMERIC | DECIMAL |
FLOAT/REAL/DOUBLE PRECISION | DOUBLE |
NUMBER | DECIMAL |
BYTE | BYTES |
VARBYTE | BYTES |
BLOB | BYTES |
CHAR | STRING |
VARCHAR | STRING |
CLOB | STRING |
DATE | DATE |
TIME | TIME_MICROS |
TIMESTAMP | TIMESTAMP_MICROS |
TIME WITH TIME ZONE | TIME_MICROS |
TIMESTAMP WITH TIME ZONE | TIMESTAMP_MICROS |
INTERVAL YEAR | STRING |
INTERVAL YEAR TO MONTH | STRING |
INTERVAL MONTH | STRING |
INTERVAL DAY | STRING |
INTERVAL DAY TO HOUR | STRING |
INTERVAL DAY TO MINUTE | STRING |
INTERVAL DAY TO SECOND | STRING |
INTERVAL HOUR | STRING |
INTERVAL HOUR TO MINUTE | STRING |
INTERVAL HOUR TO SECOND | STRING |
INTERVAL MINUTE | STRING |
INTERVAL MINUTE TO SECOND | STRING |
INTERVAL SECOND | STRING |
ST_Geometry | STRING |