Details
-
Task
-
Resolution: Done
-
Major - P3
-
None
-
None
-
None
-
None
-
QO 2021-12-13, QO 2021-12-27
Description
As part of this ticket we could consider writing either a mongosh script or Python script which POCs this process. The high level approach proposed is as follows:
1) Create a new temporary time-series collection |
2) FindOne a bucket in the original time-series collection with a mixed type min/max and obtain the bucket _id value |
3) Fetch and unpack all documents in that bucket |
4) Insert each document into a temp time-series collection in time ascending order |
5) Open a transaction |
a) For each bucket in the temp collection, copy to the original collection
|
b) Remove the original bucket document by _id
|
c) Remove all buckets in the temp collection
|
6) Commit transaction |
7) Goto Step 2 |