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.