TIBCO Data Virtualization® Adapter Online Help > TDV Teradata Adapter > Data Type Mappings
 
Data Type Mappings
Teradata to TDV Data Types
The following table shows the mapping from Teradata data types to TDV data types.
Teradata data types have these characteristics:
• FLOAT and REAL data types are synonymous with DOUBLE PRECISION.
• For Teradata version 15, the maximum length for BINARY and VARBINARY is 64000; for CHAR and VARCHAR it is 32000; for BLOB it is 2097088000; for CLOB it is 1048544000; and for JSON it is 8388096.
• For all supported versions of Teradata except version 15, the maximum length for BINARY, CHAR, VARBINARY, and VARCHAR is 32000; and the JSON data type is not supported.
• IN operator with subquery cannot be pushed down,
• The native data types BLOB, CLOB, JSON, and XML are not supported in DISTINCT, EXCEPT, GROUP BY, HAVING, INTERSECT, JOIN ON, ORDER BY or UNION clauses,
Teradata Data Type
TDV Data Type
BIGINT
BIGINT
BLOB
BLOB
BYTE
BINARY
BYTEINT
TINYINT
CHAR
CHAR
CLOB
CLOB
DATE
DATE
DECIMAL
DECIMAL
DOUBLE PRECISION
DOUBLE
FLOAT
DOUBLE
GRAPHIC
CHAR
INTEGER
INTEGER
INTERVAL DAY
INTERVAL DAY
INTERVAL DAY TO HOUR
INTERVAL DAY TO HOUR
INTERVAL DAY TO MINUTE
INTERVAL DAY TO MINUTE
INTERVAL DAY TO SECOND
INTERVAL DAY TO SECOND
INTERVAL HOUR
INTERVAL HOUR
INTERVAL HOUR TO MINUTE
INTERVAL HOUR TO MINUTE
INTERVAL HOUR TO SECOND
INTERVAL HOUR TO SECOND
INTERVAL MINUTE
INTERVAL MINUTE
INTERVAL MINUTE TO SECOND
INTERVAL MINUTE TO SECOND
INTERVAL MONTH
INTERVAL MONTH
INTERVAL SECOND
INTERVAL SECOND
INTERVAL YEAR
INTERVAL YEAR
INTERVAL YEAR TO MONTH
INTERVAL YEAR TO MONTH
LONG VARCHAR
CLOB
NUMERIC
NUMERIC
PERIOD(DATE)
VARCHAR
PERIOD(TIME)
VARCHAR
PERIOD(TIMESTAMP)
VARCHAR
PERIOD(TIME WITH TIME ZONE)
VARCHAR
PERIOD(TIMESTAMP WITH TIME ZONE)
VARCHAR
REAL
DOUBLE
SMALLINT
SMALLINT
TIME
TIME
TIME WITH ZONE
VARCHAR
TIMESTAMP
TIMESTAMP
TIMESTAMP WITH ZONE
VARCHAR
VARBYTE
VARBINARY
VARCHAR
VARCHAR
VARGRAPHIC
VARCHAR
XML
XML (version 15 and above)