-
Type: Task
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Integration
-
Fully Compatible
-
QI 2023-07-10, QI 2023-07-24, QI 2023-08-07, QI 2023-08-21
This ticket will handle implementing the validation that will check if the $group for min/max optimization can occur. The requirements for this optimization are...
- bucketMaxSpanSeconds and bucketRoundingSeconds parameters have not been changed.
- Given a predicate on timeField T, dateTrunc(T) matches the bucket boundaries. For example, if bucketMaxSpanSeconds is set to 60 seconds, then dateTrunc.unit converted to seconds multiplied by dateTrunc.binSize needs to be a multiple of bucketMaxSpanSeconds.
- The $group _id field only refers to a combination of the metaField and dateTrunc(timeField).
- The query does not use an extended range.
This ticket should also check that special timezones such as UTC +05:30 are gracefully handled.
- is depended on by
-
SERVER-78235 pushdown $group ahead of unpack with $count
- Closed
- related to
-
SERVER-79552 $group rewrite for timeseries returns incorrect result if referencing the metaField in an object
- Closed