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

Verify spilling logic in HashAgg works for $lookup HJ plans

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Won't Fix
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None

    Description

      In PM-2267 spilling to disk in HashAgg stage was implemented to support $group queries that hit the memory limit and would spill to a WT temp store when allowDiskUse=true.

      Given that we will use the HashAgg stage to build a hash table for the foreign side and accumulate the set of documents that satisfy the eq predicate between the local/foreign side keys the current spilling implementation might just work for our use-case.

      The owner of this ticket should exercise the spilling implementation in HashAgg and see if it is suitable for HJ plans. If changes need to be made to support HJ plans we should do so under this work.  

      Attachments

        Activity

          People

            anna.wawrzyniak@mongodb.com Anna Wawrzyniak
            eric.cox@mongodb.com Eric Cox (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: