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.

    Note:
    If a type is not present in the table, it is not currently supported.

    MongoDB Database TypeDremio Type
    arraylist
    binDatavarbinary
    boolboolean
    datetimestamp
    dbPointer{ “namespace”: varchar, “id”: varbinary }
    doubledouble
    intinteger (or double if store.mongo.read_numbers_as_double set)
    javascriptvarchar
    javascriptWithScope{ “code”: varchar, “scope”: { … } }
    longbigint (or double if store.mongo.read_numbers_as_double set)
    objectobject
    objectIdvarbinary
    regex{ “pattern”: varchar, “options”: varchar }
    stringvarchar
    symbolvarchar
    timestamptimestamp