Dremio Cloud
Dremio Software
 
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 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