Loading...

XML

Word

Printable

JSON

Backwards Compatibility:
Fully Compatible
Sprint:
Execution Team 2021-07-12, Execution Team 2021-07-26, Execution Team 2021-08-09

For ascending indexes, a createIndexes command on a time-series collection measurement field:

{
    createIndexes: “abc”,
    indexes: [ { key: { a : 1 } } ]
}

will be equivalent to the following operation on the underlying buckets collection:

{
    createIndexes: “system.buckets.abc”,
    indexes: [ { key: { control.max.a : 1, control.min.a : 1 } } ]
}

For descending indexes, a createIndexes command on a time-series collection measurement field:

{
    createIndexes: “abc”,
    indexes: [ { key: { a : -1 } } ]
}

will be equivalent to the following operation on the underlying buckets collection:

{
    createIndexes: “system.buckets.abc”,
    indexes: [ { key: { control.min.a : -1, control.max.a : -1 } } ]
}

is related to

SERVER-58879 listIndexes() on a time-series view does not reverse map the measurement indexes from the buckets collection

SERVER-58061 Support compound indexes on time-series metadata and measurements

SERVER-58062 Support multikey indexes on time-series measurements