On this page

    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