Even if we solve this within Pinot, it will be sam...
# general
k
Even if we solve this within Pinot, it will be same unless data is partitioned by order id
m
@Alex Presto could potentially push down partial aggregations too. I don't believe the current connector does this. Then the data transmitted should be relatively small.
You can fake it yourself by first aggregating on segment id and order id, then summing on order id. The first aggregation should be possible to push down, since data is naturally partitioned by segment id.