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 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	STRUCT
OBJECTID	VARBINARY
REGEX	{ "pattern": VARCHAR, "options": VARCHAR }
STRING	VARCHAR
SYMBOL	VARCHAR
TIMESTAMP	TIMESTAMP