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?
10/13/2021, 11:49 PM
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.
10/13/2021, 11:51 PM
@User … By pull-out, I basically mean to get D1-V1 and D1-Star as results of the same query
10/13/2021, 11:56 PM
The start node is mutually exclusive with other nodes, so the answer to 1 is no.
10/14/2021, 12:01 AM
Thanks for the reply!
10/14/2021, 12:11 AM
Its better to run two queries since they will end up using different nodes in the tree anyway