Hello everyone, Does Pinot store pre-aggregated results (for

sum

,

max

,

min

, etc) for each column defined in metricFieldsSpec for offline table segments? Can i achieve pre-aggregation for a single column without Star-tree index?

I think you'll need a startree index for pre aggregation, although you can also do some rollups as part of the realtime to offline aggregation job - https://docs.pinot.apache.org/operators/operating-pinot/pinot-managed-offline-flows

Pinot stores Min max in metadata but not sum.. you can add StarTree to achieve that

thank you 😇