MySQL Data Types

Dremio supports selecting the following MySQL Database types. The following table shows the mappings from MySQL to Dremio data types.

[info] 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 double
DECIMAL UNSIGNED double
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 integer
TINYINT UNSIGNED integer
TINYTEXT varchar
VARBINARY varbinary
VARCHAR varchar
YEAR integer

results matching ""

    No results matching ""