Even if we solve this within Pinot, it will be same unless data is partitioned by order id
m
Mark Wagner
11/07/2019, 5:03 PM
@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.
Mark Wagner
11/07/2019, 5:05 PM
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.