Hi Folks, I have a couple of questions regarding Star-Tree index: 1. In the image attached, is it possible for me to get D1-V1 and D1-Star as results of the same query? The assumption here is that since nodes in star-tree index are pre-aggregated, can I somehow pull two of them out in one-go. (I guess subqueries with 2 different filter conditions would be one solution, but Pinot does not support that) 2. In the realtime table, is it possible to use star-tree index? My understanding is that since star-tree index requires pre-aggregation, it may not be applicable to real-time tables. If that’s the case, is it possible to activate star-tree index without upserts?

1. What do you mean by pull out the nodes in one-go? 2. You can configure star-tree index for realtime, but yes upsert isn't supported with that. cc: @User

@User … By pull-out, I basically mean to get D1-V1 and D1-Star as results of the same query

The start node is mutually exclusive with other nodes, so the answer to 1 is no.

Thanks for the reply!

Its better to run two queries since they will end up using different nodes in the tree anyway