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 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 | object |
objectId | varbinary |
regex | { “pattern”: varchar, “options”: varchar } |
string | varchar |
symbol | varchar |
timestamp | timestamp |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.