Scenario

Update operations to time series collections fail due to the Updates and Deletes limitations limitations for these collection types.

The update functionality for the Time Series collections, with the below limitations, was introduced in MongoDB 5.5.

• The update command may not limit the number of documents to be updated. You must use an update command with multi: true or the updateMany() method.
• The update command may not set upsert: true.

As per internal discussion:

• The spark connector does not allow to set the required `multi: true` option.
• The spark connector implicitly sets `upsert: true` for bulk operations.

Improvement Request

Please add Spark Connector update methods which can meet the Time Series limitations. Alternatively please allow to modify the default operation options to meet the required limitations.