Teradata source data types
The following table shows the Teradata source data types that are supported when using Qlik Replicate and the default mapping to the Qlik Replicate data types.
For additional information about Qlik Replicate data types, see Replicate data types.
Teradata Data Types | Qlik Replicate Data Types |
---|---|
BLOB |
BLOB |
BYTE |
BYTES |
BYTEINT |
INT1 |
BIGINT |
INT8 |
DATE |
DATE |
DECIMAL |
REAL8 |
DOUBLE PRECISION |
REAL8 |
FLOAT |
REAL8 |
INTEGER |
INT4 |
INTERVAL DAY |
STRING (Support a maximum of 9,999 days) |
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 (Supports up to six fractional seconds) |
CHAR |
STRING |
CLOB |
CLOB |
GRAPHIC |
STRING |
INTERVAL MONTH |
STRING |
INTERVAL YEAR |
STRING |
INTERVAL YEAR TO MONTH |
STRING |
REAL |
REAL8 |
SMALLINT |
INT2 |
TIME |
TIME |
TIMESTAMP |
DATETIME |
TIMESTAMP WITH TIME ZONE |
DATETIME |
TIME WITH TIME ZONE |
TIME |
VARBYTE |
BYTES |
VARCHAR |
STRING (10) |
VARGRAPHIC |
STRING (10) |
NUMERIC |
If scale is => 0 and <=37, then: NUMERIC (p,s) If scale is => 38, then: VARCHAR (45) |
CHAR VARYING |
STRING |
LONG VARCHAR |
STRING |