[SERVER-33788] db.createView to allow UNION of multiple collections Created: 09/Mar/18  Updated: 02/Apr/18  Resolved: 09/Mar/18

Status: Closed
Project: Core Server
Component/s: Aggregation Framework
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Major - P3
Reporter: Mike Hsu Assignee: Kelsey Schubert
Resolution: Duplicate Votes: 0
Labels: read-only-views
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-23201 provide union operator to union two c... Closed
Participants:

 Description   

Would like to implement "partitioned collection" with a view of multiple collections. For example, a rolling 12 monthly collections UNIONed to a view. rebuild the view every month to include the new moth and drop the oldest collection. This will avoid the slow performance of deleting one month of data with could be over 300 million documents.



 Comments   
Comment by Kelsey Schubert [ 09/Mar/18 ]

Hi mhsuqcom,

Thanks for the feature request. As Kyle mentions, SERVER-23201 would provide the functionality your looking for, and so I'm closing this ticket as a duplicate. Feel free to vote for SERVER-23201 and watch it for updates.

Kind regards,
Kelsey

Comment by Kyle Suarez [ 09/Mar/18 ]

This could be accomplished with SERVER-23201.

Generated at Thu Feb 08 04:34:35 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.