[DRILL-8118] Add Option to Allow Disk Use on Mongo Queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.20.0
• Component/s: Storage - MongoDB
• Assignee: Charles Givre
• Reporter: Charles Givre
• Created: 29/Jan/22 23:41
• Updated: 31/Jan/22 09:44
• Resolved: 31/Jan/22 09:44

Description

MongoDB has a strange feature  whereby queries which use more than 100MB of memory will by default fail.  Mongo allows the user to specify whether they want the query to spill to disk which allows larger queries but at a performance cost.

This minor PR adds the ability for a user to specify whether they want this option included in Mongo queries.  This only affects aggregate queries in Mongo.