Dremio Cloud
Dremio Software
 
On this page

    MongoDB Data Types

    Dremio supports selecting the following MongoDB Database types. The following table shows the mappings from MongoDB to Dremio data types. If there are additional MongoDB types not listed in the table, then those types are not supported in Dremio.

    MongoDB Database Type Dremio Type
    ARRAY LIST
    BINDATA VARBINARY
    BOOL BOOLEAN
    DATE TIMESTAMP
    DBPOINTER { “namespace”: VARCHAR, “id”: VARBINARY }
    DOUBLE DOUBLE
    INT INTEGER (or DOUBLE if store.mongo.read_numbers_as_double set)
    JAVASCRIPT VARCHAR
    JAVASCRIPTWITHSCOPE { “code”: VARCHAR, “scope”: { … } }
    LONG BIGINT (or DOUBLE if store.mongo.read_numbers_as_double set)
    OBJECT STRUCT
    OBJECTID VARBINARY
    REGEX { “pattern”: VARCHAR, “options”: VARCHAR }
    STRING VARCHAR
    SYMBOL VARCHAR
    TIMESTAMP TIMESTAMP