Hadoop to Teradata Data Type Mappings - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
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