IBM Db2 Data Types
The following table shows the mappings from Db2 to Dremio data types.
note
If a type is not present in the table, it is not currently supported.
| Db2 Database Type | Dremio Type |
|---|---|
| BIGINT | BIGINT |
| BLOB | VARCHAR |
| BOOLEAN | BOOLEAN |
| CHAR | VARCHAR |
| CHAR () FOR BIT DATA | VARCHAR |
| CLOB | VARCHAR |
| DATE | DATE |
| DBCLOB | VARCHAR |
| DECFLOAT | DECIMAL |
| DECIMAL | DECIMAL |
| DOUBLE | DOUBLE |
| GRAPHIC | VARCHAR |
| INTEGER | INTEGER |
| LONG VARCHAR | VARCHAR |
| LONG VARCHAR FOR BIT DATA | VARCHAR |
| LONG VARGRAPHIC | VARCHAR |
| REAL | DOUBLE |
| SMALLINT | INTEGER |
| TIME | TIME |
| TIMESTAMP | TIMESTAMP |
| VARCHAR | VARCHAR |
| VARCHAR () FOR BIT DATA | VARCHAR |
| VARGRAPHIC | VARCHAR |