[SERVER-77965] Allow timeseries queries to run in SBE Created: 09/Jun/23  Updated: 29/Oct/23  Resolved: 10/Aug/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.1.0-rc0

Type: Task Priority: Major - P3
Reporter: Ian Boros Assignee: Irina Yatsenko (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Problem/Incident
Related
related to SERVER-79902 Disable explain check in SBE for time... Closed
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Participants:
Linked BF Score: 109

 Description   

In mongo::getExecutor() we checks whether the canonical query is SBE compatible and the check currently rejects any query that runs against a TS bucket collection (see isQuerySbeCompatible). This guard triggers even if the canonical query is empty. The guard should be augmented with a check for the feature flag for allowing to lower TS queries to SBE.

We will need more elaborate heuristics for whether to run a TS query in SBE but while under the feature flag we can start with a blanket acceptance and file separate tickets for each query shape we'd want to block as they would likely require modifying different places in the code. Allowing the TS queries through will let us start end-to-end testing right away.

Note: we should block non-inclusion queries as part of this ticket because we simply cannot lower bucket unpacking in this case (the above comment is about potentially losing perf but lowering of a partial pipeline would "just work" from the correctness point of view)



 Comments   
Comment by Githook User [ 10/Aug/23 ]

Author:

{'name': 'Irina Yatsenko', 'email': 'irina.yatsenko@mongodb.com', 'username': 'IrinaYatsenko'}

Message: SERVER-77965 Allow timeseries queries to run in SBE
Branch: master
https://github.com/mongodb/mongo/commit/bbe64d5fd2d41b8cb439afc9756c87091e576bb0

Generated at Thu Feb 08 06:37:06 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.