Skip to main content

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 TypeDremio Type
BITBOOLEAN
BIGINTBIGINT
BIGINT UNSIGNEDBIGINT
BINARYVARBINARY
BLOBVARBINARY
CHARVARCHAR
DATEDATE
DATETIMETIMESTAMP
DECIMAL UNSIGNEDDECIMAL
DOUBLEDOUBLE
DOUBLE PRECISIONDOUBLE
ENUMVARCHAR
FLOATFLOAT
INTINTEGER
INT UNSIGNEDBIGINT
INTEGERINTEGER
INTEGER UNSIGNEDBIGINT
LONG VARBINARYVARBINARY
LONG VARCHARVARCHAR
LONGBLOBVARBINARY
LONGTEXTVARCHAR
MEDIUMBLOBVARBINARY
MEDIUMINTINTEGER
MEDIUMINT UNSIGNEDINTEGER
MEDIUMTEXTVARCHAR
NUMERICNUMERIC
REALDOUBLE
SETVARCHAR
SMALLINTINTEGER
SMALLINT UNSIGNEDINTEGER
TEXTVARCHAR
TIMETIME
TIMESTAMPTIMESTAMP
TINYBLOBVARBINARY
TINYINTINTEGER
TINYINT UNSIGNEDINTEGER
TINYTEXTVARCHAR
VARBINARYVARBINARY
VARCHARVARCHAR
YEARINTEGER