Hi team , I have a doubt in startree in which I give a filter column which is not in any of the dimensions or measures but still the star tree works , but The details given by the pinot doc is

All aggregation function + column pairs in the query must exist in the StarTree index.
All dimensions that appear in filter predicates and group-by should be StarTree dimensions.

So how does star tree work in this scenario?

I assume you meant that filter is not in the split order of startree. In this scenario startree index won’t be used, and the engine will use any other available indexing for the query

But that query uses Star tree filter and those measures @Mayank

What do you mean? How do you know it uses star tree to execute the query

I use explain plan for that query mayank , than I noticed in project star tree aggregated cols and at last FILTER STARTREE INDEX is there

Can you share the query, the star tree config and output or explain plan?

Ok I will @Mayank