On this page

    MySQL Data Types

    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 TypeDremio Type
    BITboolean
    BIGINTbigint
    BIGINT UNSIGNEDbigint
    BINARYvarbinary
    BLOBvarbinary
    CHARvarchar
    DATEdate
    DATETIMEtimestamp
    DECIMAL UNSIGNEDdecimal (as of 4.0)
    DOUBLEdouble
    DOUBLE PRECISIONdouble
    ENUMvarchar
    FLOATfloat
    INTinteger
    INT UNSIGNEDinteger
    INTEGERinteger
    INTEGER UNSIGNEDinteger
    LONG VARBINARYvarbinary
    LONG VARCHARvarchar
    LONGBLOBvarbinary
    LONGTEXTvarchar
    MEDIUMBLOBvarbinary
    MEDIUMINTinteger
    MEDIUMINT UNSIGNEDinteger
    MEDIUMTEXTvarchar
    NUMERICdouble
    REALdouble
    SETvarchar
    SMALLINTinteger
    SMALLINT UNSIGNEDinteger
    TEXTvarchar
    TIMEtime
    TIMESTAMPtimestamp
    TINYBLOBvarbinary
    TINYINTboolean
    TINYINT UNSIGNEDinteger
    TINYTEXTvarchar
    VARBINARYvarbinary
    VARCHARvarchar
    YEARinteger