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 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)
    OBJECTSTRUCT
    OBJECTIDVARBINARY
    REGEX{ “pattern”: VARCHAR, “options”: VARCHAR }
    STRINGVARCHAR
    SYMBOLVARCHAR
    TIMESTAMPTIMESTAMP