MongoDB Data Types

Dremio supports selecting the following MongoDB Database types. The following table shows the mappings from MongoDB to Dremio data types.

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

MongoDB Database Type Dremio Type
array list
binData varbinary
bool boolean
date timestamp
dbPointer { “namespace”: varchar, "id": varbinary }
decimal double
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 object
objectId varbinary
regex { "pattern": varchar, "options": varchar }
string varchar
symbol varchar
timestamp timestamp

results matching ""

    No results matching ""