MySQL Data Types
Dremio supports MySQL data types, as shown in the following table which provides the mappings from MySQL to Dremio data types. If there are additional MySQL types not listed in the table, then those types are not supported in Dremio.
| MySQL Data Type | Dremio Type |
|---|---|
| BIT | BOOLEAN |
| BIGINT | BIGINT |
| BIGINT UNSIGNED | BIGINT |
| BINARY | VARBINARY |
| BLOB | VARBINARY |
| CHAR | VARCHAR |
| DATE | DATE |
| DATETIME | TIMESTAMP |
| DECIMAL UNSIGNED | DECIMAL |
| DOUBLE | DOUBLE |
| DOUBLE PRECISION | DOUBLE |
| ENUM | VARCHAR |
| FLOAT | FLOAT |
| INT | INTEGER |
| INT UNSIGNED | BIGINT |
| INTEGER | INTEGER |
| INTEGER UNSIGNED | BIGINT |
| LONG VARBINARY | VARBINARY |
| LONG VARCHAR | VARCHAR |
| LONGBLOB | VARBINARY |
| LONGTEXT | VARCHAR |
| MEDIUMBLOB | VARBINARY |
| MEDIUMINT | INTEGER |
| MEDIUMINT UNSIGNED | INTEGER |
| MEDIUMTEXT | VARCHAR |
| NUMERIC | NUMERIC |
| REAL | DOUBLE |
| SET | VARCHAR |
| SMALLINT | INTEGER |
| SMALLINT UNSIGNED | INTEGER |
| TEXT | VARCHAR |
| TIME | TIME |
| TIMESTAMP | TIMESTAMP |
| TINYBLOB | VARBINARY |
| TINYINT | INTEGER |
| TINYINT UNSIGNED | INTEGER |
| TINYTEXT | VARCHAR |
| VARBINARY | VARBINARY |
| VARCHAR | VARCHAR |
| YEAR | INTEGER |