Teradata to Hadoop 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 Teradata to Hadoop, 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.

Teradata to Hadoop Data Type Mapping for TDCH Utility

Source Teradata Type Default Hadoop Type Possible Hadoop Type
BIGINT BIGINT BIGINT, TINYINT, DOUBLE, FLOAT, INT, SMALLINT, STRING
BYTEINT TINYINT BIGINT, TINYINT, DOUBLE, FLOAT, INT, SMALLINT, STRING
DECIMAL, DOUBLE DOUBLE BIGINT, TINYINT, DOUBLE, FLOAT, INT, SMALLINT, STRING
FLOAT FLOAT BIGINT, TINYINT, DOUBLE, FLOAT, INT, SMALLINT, STRING
INT, INTEGER INT BIGINT, TINYINT, DOUBLE, FLOAT, INT, SMALLINT, STRING
SMALLINT SMALLINT BIGINT, TINYINT, DOUBLE, FLOAT, INT, SMALLINT, STRING
TIMESTAMP TIMESTAMP TIMESTAMP, STRING
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, BYTE, BLOB STRING STRING

Teradata to Hadoop Data Type Mapping for T2H Utility

Source Teradata Type Default Hadoop Type Possible Hadoop Type
DECIMAL DECIMAL BIGINT, TINYINT, DOUBLE, FLOAT, INT, SMALLINT, STRING
NUMERIC DECIMAL BIGINT, TINYINT, DOUBLE, FLOAT, INT, SMALLINT, STRING
CHAR, CHARACTER CHAR CHAR, STRING
DATE DATE DATE, STRING
VARBYTE, BYTE, BLOB BINARY BINARY

All other type mappings are the same as in TDCH Utility.

CHAR type: In Hadoop (Hive) CHAR type length range is 1 to 255. If the source data length is more than 255, T2H truncates the source data to 255 characters (or truncates up to the length of the target CHAR column).

Data Mover does not support the following for Teradata to Hadoop:
  • Moving tables with extended object names (EON) to Hadoop
  • Custom UDT
  • Teradata GEOSPATIAL, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC types
  • BLOB or CLOB column length over 64 KB
  • BYTE, VARBYTE, or BLOB column contents converted to HEX
  • Hive MAP, ARRAY, and STRUCT types
  • Hive Union Type