The following table lists the common mappings for Hadoop to Teradata, if the target table does not exist. If the target table does exist, ensure the data mapping is correct to avoid an error. The default type is chosen if you do not specify a type. The possible type identifies acceptable data type options, and only one type can be specified.
Source Hadoop Type | Default Teradata Type | Possible Teradata Type |
---|---|---|
BIGINT | BIGINT | BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT |
TINYINT | BYTEINT | BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT |
DECIMAL, DOUBLE | DOUBLE | BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT |
FLOAT | FLOAT | BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT |
INT, INTEGER | INT | BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT |
SMALLINT | SMALLINT | BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT |
TIMESTAMP | TIMESTAMP | TIMESTAMP |
STRING | VARCHAR | CHAR, CHARACTER, VARCHAR, DATE, CLOB, INTERVAL DAY, INTERVAL DAY HOUR, INTERVAL DAY MINUTE, INTERVAL DAY SECOND, INTERVAL HOUR, INTERVAL HOUR MINUTE, INTERVAL HOUR SECOND, INTERVAL MINUTE, INTERVAL MINUTE SECOND, INTERVAL MONTH, INTERVAL SECOND, INTERVAL YEAR, INTERVAL YEAR MONTH, VARBYTE 1, BYTE 1, BLOB 1 |
BINARY 2 | VARBYTE | VARBYTE, BYTE, BLOB |
ARRAY | VARCHAR | VARCHAR |
STRUCT | VARCHAR | VARCHAR |
MAP | VARCHAR | VARCHAR |
1STRING to VARBYTE, BYTE, and BLOB types are supported only via TDCH. 2BINARY Hadoop data type is supported only through QueryGrid T2H. |
Data Mover does not support the following for Hadoop to Teradata:
- Custom UDT
- Teradata GEOSPATIAL, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC types
- Hive Union Type