Aster 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 mapping for Aster 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. You can chose the specific data type mapping for source Aster data type, which are listed under possible target teradata data types.
Source Aster Type Default Teradata Type Possible Teradata Type
BIGINT BIGINT BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT
BOOT, INTERVAL, IP4, IP4RANGE, UUID CHARACTER VARCHAR
NUMERIC CHARACTER BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT
BIT CHARACTER BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT
INTEGER INTEGER BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT
REAL, DOUBLE PRECISION FLOAT BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT
BYTEA BYTE CHARACTER, VARCHAR
DATE DATE CHARACTER, VARCHAR
TIME TIME CHARACTER, VARCHAR
TIMESTAMP TIMESTAMP CHARACTER, VARCHAR
CHARACTER CHARACTER VARCHAR, BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT, TIME, DATE, TIMESTAMP
VARCHAR, TEXT, VARBIT VARCHAR CHARACTER, BIGINT, BYTEINT, DOUBLE, FLOAT, INT, SMALLINT, TIME, DATE, TIMESTAMP

Usage Notes

Data Mover does not support the following for Aster to Teradata:
  • The JSON data type is not allowed by Aster and cannot be moved from Aster to Teradata.