Hi Pinot experts, I’m new to this analytics realm with Pinot and I have a general question: Does pinot support something like “view” that is common in OLTP? What I’m looking for is a way to optimize frequently used queries that require aggregation over data entries, e.g,: sum of total sales for the past 30, 60, 90 days which aggregates on a designated time column. Another option I’m thinking of is to create separate table for this aggregation which is derived from the fact table and use a scheduled job to update it. Any idea? Thanks in advance!

The standard Pinot approach would be to define a star tree index with the time column as the dimension and the sales column as the aggregate. That should get you very fast results for pretty much any date range.

That is interesting. I will take a look on that. Thanks!

@User I'd first suggest to evaluate the out of the box performance for your queries. Only if the performance needs to be improved further, you can explore StarTree for partial pre-materialization as @User suggested.

Thanks. We will benchmark and see would StarTree index helps