• Type: Task
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      There's some pipeline shapes visible in their tests, but I think we can also just run the compiler separately to investigate interesting SQL queries.

      We could focus on how JOINs and subqueries, and other common SQL queries are translated.

      Then we can determine if there are any pipeline shapes we need to support better with rewrites and analysis, for example to ensure JOO can apply, we can use an index, sort order, etc.

      For example I can see a number of $replaceWith with $mergeObjects after $lookup:

      { "$replaceWith": { "$mergeObjects": ["$$ROOT", "$eca58228-b657-498a-b76e-f48a9161a404"] } }
      

            Assignee:
            Unassigned
            Reporter:
            Vesko Karaganev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: