https://pinot.apache.org/ logo
#general
Title
# general
a

Alex

11/20/2019, 4:03 AM
@User thank you! Was looking at it earlier, but still unclear where sum is calculated :) From your perspective, how hard will it be to add dynamic aggregations (sums, counts, min, ...). Aggregation spec can be extended easily, how about actual calculations?
n

Neha Pawar

11/20/2019, 6:05 PM
I don't think it should be very hard. @Mayank ^^ wdyt?
m

Mayank

11/20/2019, 6:11 PM
Definitely doable, but may require some work. For example, we may want have multiple aggregation functions on the same column, which would mean we would need to introduce some sort of derived column, and ensure that the query execution layer understands that. I think @Jackie may have already done this for StarTree, so there may be some work to leverage from there.
a

Alex

11/20/2019, 8:01 PM
That what I thought as well. Aggregations spec can be extended with derived columns (name, source column, function)
k

Kishore G

11/20/2019, 9:11 PM
There is already a concept of derived columns in schema
We dint productionize it.