[SERVER-85432] Investigation - feasibility of running $search on non-materialized views Created: 19/Jan/24  Updated: 29/Jan/24

Status: Investigating
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Question Priority: Major - P3
Reporter: Alexander Lukyanchikov Assignee: Ted Tuckman
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Integration
Participants:

 Description   

In scope of the Index Time Enrichment project, Atlas Search plans to add support for executing queries on views. That would require the following changes on the server side:

  • Support execution of the $_internalSearchIdLookup stage inside a view
  • Implement views with $search such that the view definition is inserted into the pipeline after the $search (and $idLookup) stage but before the rest of the user pipeline
  • If the search is executed on a view, mongot request should include the view name and the corresponding source collection UUID
  • Allow index management commands to work with views: https://www.mongodb.com/docs/manual/reference/method/js-atlas-search/

We'd like to investigate if these changes are feasible to implement and roughly estimate the effort.


Generated at Thu Feb 08 06:57:44 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.