Questions about lattice
I am new to calcite, and I am looking at using lattice to speed up OLAP query against a SQL compatible database.
I do have a couple of questions I hope someone with deep knowledge of calcite can shed some lights on.
1. My understanding is tile is materialized in-memory, and it is natural to wonder if there is any provider model in place to choose an external cache/storage to manage materialized aggregates (and share them among connections) for the purpose of scale in a cluster environment.
2. I can manage populating aggregates in a SQL table or view as part of my nightly ETL process, so what is the best way to use calcite lattice only for query optimization and rewrite, but not for aggregates materialization.
Thanks in advance.