Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-63740

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

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

      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:
            backlog-query-execution [DO NOT USE] Backlog - Query Execution
            Reporter:
            mihai.andrei@mongodb.com Mihai Andrei
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: