Hi! I have two dimensions (customers and sellers) with a fact table with order data. We would like to aggregate the order data by customers and sellers, such as aggregate order amount. We would like to use the Star-tree index, but, the customer can change at any time (name, address, etc) and in the Pinot documentation it says that it does not accept upsert using Star-tree index (https://docs.pinot.apache.org/basics/data-import/upsert#limitations…). What would be the best solution using Pinot?

Have you tried using without star tree? From your description, it seems that regular indexing should work just fine?

Thanks, we will give it a try. One other question is whether we should pre-aggregate the data or if it makes sense to do the join between clients and sellers during the query using Presto. Because the client data can change any time (such as client address).

Try lookup join feature in Pinot

tks, @User.