Skip to main content

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