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.