| Category | Teradata Data Type | Teradata DataType Code | Equivalent Type exists in Iceberg? | Iceberg Data Type |
|---|---|---|---|---|
| Numeric | BYTEINT | 7 | No | INTEGER - Use the closest type |
| Numeric | SMALLINT | 8 | No | INTEGER - Use the closest type |
| Numeric | INTEGER | 9 | Yes | INTEGER |
| Numeric | BIGINT | 36 | Yes | LONG |
| Numeric | REAL/FLOAT | 10 | Yes | DOUBLE |
| Numeric | DECIMAL(p,s) | 11 | Yes | DECIMAL(p,s) |
| Numeric | NUMBER(p,s) | 12 | Yes | DECIMAL(p,s) |
| Numeric | NUMBER, NUMBER(*,s) | N/A | No | Not supported |
| Date/Time | DATE | 15 | Yes | DATE |
| Date/Time | TIME | 16 | Yes | TIME |
| Date/Time | TIME WITH TIME ZONE | N/A | No | Not supported |
| Date/Time | TIMESTAMP | 17 | Yes | TIMESTAMP |
| Date/Time | TIMESTAMP WITH TIME ZONE | 32 | Yes | TIMESTAMP_WTZ |
| Date/Time | INTERVAL | 19 | No | Not Supported |
| Character | CHAR(n) n <= 64000 for Latin n <= 32000 for Unicode |
1 | No | STRING UTF8 - Use the closest type |
| Character | VARCHAR(n) n <=64000 for Latin n <= 32000 for Unicode |
2 | Yes | STRING UTF8
|
| Character | CLOB | N/A | Yes | STRING UTF8 Not Supported(in phase 1) |
| Binary | BYTE(n) n <=64000 |
3 | Yes | FIXED(n) |
| Binary | VARBYTE(n) n <=64000 |
4 | Yes | binary |
| Binary | BLOB(n) | 33 | Yes | binary Not supported (in phase 1) |
| External UDT | UDT | N/A | No | Not Supported |
| Internal UDT | BSON/JSON | N/A | No | Not Supported |
| Internal UDT | XML | N/A | No | Not Supported |
| Internal UDT | PERIOD | N/A | No | Not Supported |
| Internal UDT | ARRAY/VARRAY | N/A | No | Not Supported |
| Internal UDT | DATASET | N/A | No | Not Supported |
| Internal UDT | VECTOR | N/A | No | Not Supported |
| Internal UDT | Geospatial types - ST_GEOMETRY, MBR, MBB | N/A | No | Not Supported |