Hello 😄 Does Pinot have any support for hierarchical aggregations ? Say we have a tree like structure, with values at the leaves, is there an efficient way to get the values at the intermediates & root nodes ? (Tree size can be ~10 layer deep, with ~10000-100000 leaves)

Have you looked at Star tree index?

I've read a bit about it, not sure it could fit that use case ? (looks like it could 🙂)

Do you have pointers on how to configure it / how the data should look like to make it work in that scenario ? Maybe an important detail is that I should have said "_tree*S"*_ Ideally only known at runtime (not integration time) I'll look into it first