Time Series Collection Limitations

Unsupported Features

MongoDB does not support the following features with time series collections:

• Atlas Search

• Change streams

• Client-Side Field Level Encryption

• Database Triggers

• GraphQL API (deprecated)

• Schema validation rules

• reIndex

• renameCollection

Aggregation $merge

You cannot use the $merge aggregation stage to add data from another collection to a time series collection. Use the $out aggregation stage to write documents to a time series collection.

You can use $merge to move data from a time series collection to another collection.

distinct Command

Due to the unique data structure of time series collections, MongoDB can't efficiently index them for distinct values. Avoid using the distinct command or db.collection.distinct() helper method on time series collections. Instead, use a $group aggregation to group documents by distinct values.

For example, to query for distinct meta.type values on documents where meta.project = 10, instead of:

db.foo.distinct("meta.type", {"meta.project": 10})

Use:

db.foo.createIndex({"meta.project":1, "meta.type":1})
db.foo.aggregate([{$match: {"meta.project": 10}},
                  {$group: {_id: "$meta.type"}}])

This works as follows:

1. Creating a compound index on meta.project and meta.type and supports the aggregation.

2. The $match stage filters for documents where meta.project = 10.

3. The $group stage uses meta.type as the group key to output one document per unique value.

Geospatial Queries

Time series collections only support the $geoNear aggregation stage for sorting geospatial data from queries against 2dsphere indexes. You can't use $near and $nearSphere operators on time series collections

Document Size

The maximum size for documents within a time series collection is 4 MB.

Extended Date Range

If a time series collection contains documents with timeField timestamps before 1970-01-01T00:00:00.000Z or after 2038-01-19T03:14:07.000Z, no documents are deleted from the collection by the TTL "time to live" feature.

For details on TTL deletes, see Expire Data from Collections by Setting TTL.

If your time series collection contains documents with timeField timestamps before 1970-01-01T00:00:00.000Z or after 2038-01-19T03:14:07.000Z, create an index on the timeField to optimize queries.

Updates

Update commands must meet the following requirements:

• You can only match on the metaField field value.

• You can only modify the metaField field value.

• Your update document can only contain update operator expressions.

• Your update command must not limit the number of documents to be updated. Set multi: true or use the updateMany() method.

• Your update command must not set upsert: true.

To automatically delete old data, set up automatic removal (TTL).

Time Series Secondary Indexes

MongoDB partially supports the following indexes on time series collections:

• You can only create multikey indexes on the metaField.

• You can only create 2d indexes on the metaField.

• You can only create sparse indexes on the metaField.

MongoDB doesn't support the following index types on time series collections:

• Text indexes

• Unique indexes

If there are secondary indexes on time series collections and you need to downgrade the feature compatibility version (fCV), you must first drop any secondary indexes that are incompatible with the downgraded fCV. For more information, see setFeatureCompatibilityVersion.

Capped Collections

You cannot create a time series collection as a capped collection.

Modification of Collection Type

You can only set the collection type when you create a collection:

• You cannot convert an existing collection into a time series collection.

• You cannot convert a time series collection into a different collection type.

To move data from an existing collection to a time series collection, migrate data into a time series collection.

Modification of timeField and metaField

You can only set a collection's timeField and metaField parameters when you create the collection. You cannot modify these parameters later.

Granularity

db.runCommand({
   collMod: "timeseries",
   timeseries: { bucketMaxSpanSeconds: 3600, bucketRoundingSeconds: 3600 }
})

Sharding

Time series collections are subject to several sharding limitations.

Transactions

You cannot write to time series collections in transactions.

Views

• Time series collections are writable non-materialized views. Limitations for views apply to time series collections.

• You cannot create a view from a time series bucket collection namespace (namely, a collection prefixed with system.buckets).

Snapshot Isolation

Read operations on time series collections with read concern "snapshot" guarantee snapshot isolation only in the absence of concurrent drop or rename operations on collections in the read operation. Re-creating a time series collection on the same namespace with different granularity setting does not yield full snapshot isolation.