下表列出了目标表不存在时从 Hadoop 到 Teradata 的常见映射。如果目标表存在，请确保数据映射正确，以避免错误。如果未指定类型，则会选择缺省类型。可能的类型用于确定可接受的数据类型选项，您只能指定一种类型。
| 源 Hadoop 类型 | 缺省 Teradata 类型 | 可能的 Teradata 类型 |
|---|---|---|
| BIGINT | BIGINT | BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT |
| CHAR | CHAR | 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 |
| 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 |
| VARCHAR | 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 |
1只有 TDCH 支持 STRING、VARBYTE、BYTE 和 BLOB 类型。 2只有 QueryGrid T2H 支持 BINARY Hadoop 数据类型。 |
||
对于从 Hadoop 到 Teradata，Data Mover 不支持以下数据类型：
- 自定义 UDT
- Teradata GEOSPATIAL、GRAPHIC、VARGRAPHIC 和 LONG VARGRAPHIC 类型
- Hive Union 类型