-
Type:
Task
-
Resolution: Incomplete
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
None
-
None
-
None
-
None
-
None
-
None
-
None
db.order_lineitem.aggregate([
{
$match: {
$and: [
{ "order.o_orderdate": { $gte: ISODate("1992-01-01") } },
{ "order.o_orderdate": { $lte: ISODate("1996-01-01") } },
]
},
},
{
$group: {
_id: "$order.o_orderkey",
priority: { $last: "$order"},
someSum: {
$sum: "$l_extendedprice"
},
anotherSum1: {
$sum: "$l_discount"
},
anotherSum2: {
$sum: "$l_tax"
},
anotherSum3: {
$sum: "$l_quantity"
},
count: { $sum: 1 }
}
}
]
)
- Investigate perf, see if there's any low-hanging fruit
- if no low hanging fruit, I'd still like to understand where all the time is spent in this query
- depends on
-
SERVER-70726 Support pushing down as per-path filters AND of supported expressions on the same path
-
- Closed
-