Teradata Data Types
Dremio supports selecting the following Teradata Database types. The following table shows the mappings from Teradata to Dremio data types.
Note:
If a type is not present in the table, it is not currently supported.
| Teradata Database Type | Dremio Type |
|---|---|
| BIGINT | bigint |
| BLOB | varbinary |
| BYTE | varbinary |
| BYTEINT | integer |
| CHAR | varchar |
| DATE | date |
| FLOAT | double |
| GRAPHIC | varchar |
| INTEGER | integer |
| LONG VARCHAR | varchar |
| LONG VARGRAPHIC | varchar |
| LONGVARCHAR | varchar |
| NUMBER | decimal |
| SMALLINT | integer |
| TIME WITH TIMEZONE | time |
| TIME | time |
| TIMESTAMP WITH TIMEZONE | timestamp |
| TIMESTAMP | timestamp |
| VARBYTE | varbinary |
| VARCHAR | varchar |
| VARGRAPHIC | varchar |