The following table lists the common mappings for Teradata to Hadoop, if the target table does not exist. If the target table does exist, make sure 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 |
CHAR, CHARACTER | CHAR | CHAR, VARCHAR, 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 |
VARCHAR | VARCHAR | VARCHAR, CHAR, STRING |
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, VARCHAR, STRING |
DATE | DATE | DATE, STRING |
VARCHAR | VARCHAR | CHAR, VARCHAR, 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, and 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