3. If there is a separate StarTree index for every segment, how do Brokers aggregate the results from them? For example, I have a table containing movies ratings. One segment holds ratings from August and the second one from September. I configured my StarTree to calculate the average for the rating column. The first segment has a pre-computed value for August. Let's assume it's 4.7. For the second segment, it's 4.95. Now imagine that I execute a query to get the average rating from those two months (August and September). How can the Broker merge the results from these two segments?

Average is stored as sum + count internally, to keep it additive.

It makes a lot of sense, thanks