Dremio supports selecting the following MySQL Database types. The following table shows the mappings from MySQL to Dremio data types.
Note: If a type is not present in the table, it is not currently supported.
| MySQL Database Type | Dremio Type |
|---|---|
| BIT | boolean |
| BIGINT | bigint |
| BIGINT UNSIGNED | bigint |
| BINARY | varbinary |
| BLOB | varbinary |
| CHAR | varchar |
| DATE | date |
| DATETIME | timestamp |
| DECIMAL UNSIGNED | decimal (as of 4.0) |
| DOUBLE | double |
| DOUBLE PRECISION | double |
| ENUM | varchar |
| FLOAT | float |
| INT | integer |
| INT UNSIGNED | integer |
| INTEGER | integer |
| INTEGER UNSIGNED | integer |
| LONG VARBINARY | varbinary |
| LONG VARCHAR | varchar |
| LONGBLOB | varbinary |
| LONGTEXT | varchar |
| MEDIUMBLOB | varbinary |
| MEDIUMINT | integer |
| MEDIUMINT UNSIGNED | integer |
| MEDIUMTEXT | varchar |
| NUMERIC | double |
| REAL | double |
| SET | varchar |
| SMALLINT | integer |
| SMALLINT UNSIGNED | integer |
| TEXT | varchar |
| TIME | time |
| TIMESTAMP | timestamp |
| TINYBLOB | varbinary |
| TINYINT | boolean |
| TINYINT UNSIGNED | integer |
| TINYTEXT | varchar |
| VARBINARY | varbinary |
| VARCHAR | varchar |
| YEAR | integer |