Hadoop 到 Teradata 数据类型映射 - Teradata Data Mover

Teradata® Data Mover 用户指南

Product
Teradata Data Mover
Release Number
16.20
Published
2021 年 11 月
Language
中文 (简体)
Last Update
2021-12-02
dita:mapPath
zh-CN/wph1512683331242.ditamap
dita:ditavalPath
zh-CN/mpm1591127278842.ditaval
dita:id
B035-4101
Product Category
Analytical Ecosystem
下表列出了目标表不存在时从 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 类型