https://pinot.apache.org/ logo
e

Elon

08/11/2020, 10:56 PM
In the docs it just says metric columns "typically" appear in aggregations but in this case dimension columns appear in the aggregations - and we don't see any issue with that. Are there any caveats to aggregating on dimension columns or grouping by metric columns?
m

Mayank

08/11/2020, 10:59 PM
In general the code does not prevent aggregations on dimension columns. However, for cases such as when enabling
aggregateMetrics
require dimensions and metrics defined as intended because these features need to know which columns (are metrics) need to be aggregated when consuming realtime. So as a best practice, we would recommend having dimensions and metrics defined as intended.
e

Elon

08/11/2020, 11:00 PM
Thanks! is the "enable aggregateMetrics" a config parameter?
m

Mayank

08/11/2020, 11:00 PM
yes, tableIndexingConfig
e

Elon

08/11/2020, 11:00 PM
Thanks so much!!!
m

Mayank

08/11/2020, 11:00 PM
👍