https://pinot.apache.org/ logo
#general
Title
# general
p

Prateek Singhal

10/13/2021, 11:43 PM
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?
m

Mayank

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. cc: @User
p

Prateek Singhal

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
m

Mayank

10/13/2021, 11:56 PM
The start node is mutually exclusive with other nodes, so the answer to 1 is no.
p

Prateek Singhal

10/14/2021, 12:01 AM
Thanks for the reply!
k

Kishore G

10/14/2021, 12:11 AM
Its better to run two queries since they will end up using different nodes in the tree anyway