Investigate pushing down $lookup stages against a regular collection even if other secondary collections are sharded or are views

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Suppose we have an aggregate pipeline consisting of two $lookups, the first of which targets a ‘from’ collection that is neither sharded nor a view, but the second of which is a view (or sharded). Currently, when the AutoGet for multiple collections is acquired, the fact that one of the secondary namespaces is sharded/a view will inhibit the pushdown of any $lookup stages in the front of the pipeline that target regular collections . This ticket tracks the work to relax this restriction so that any $lookup stage in the front of the pipeline can be pushed down, even if later $lookup stages target views or sharded collections.

              Assignee:
              [DO NOT USE] Backlog - Query Execution
              Reporter:
              Mihai Andrei
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: