Hadoop to Teradata Data Type Mappings

Teradata Data Mover User Guide

brand
Analytical Ecosystem
prodname
Teradata Data Mover
vrm_release
16.10
category
User Guide
featnum
B035-4101-067K
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