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

Avoid object materialization for evaluation of field path expressions in column scan plans

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Query Execution

    Description

      In order to evaluate a field path expression (e.g. "$address.state"), we materialize an object and then evaluate the expression over that object. The goal of this ticket is to avoid creating the intermediate object when it is created only for the purpose of evaluating field path expressions.

      This will involve several sub-tasks/steps. Roughly:

      1) We will have to support evaluation of field path expressions using an SBE expression rather than an SBE plan stage tree.
      2) We will have to support evaluation of field path expressions directly over array info.
      3) We will need to track the use of field path expressions in the stage builder, and associate each one with a slot. We will attempt to do this only for certain query "shapes."

      This work will be broken up into sub-tasks as we learn more. This ticket is to track the goal of avoiding materialization for simple $group queries.

      Attachments

        Activity

          People

            backlog-query-execution Backlog - Query Execution
            ian.boros@mongodb.com Ian Boros
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: