Short answer: yes, if you use lattices. Remember, Calcite has two mechanisms for matching materialized views: the "general purpose" mechanism, and lattices.
Using general purpose mechanism you can declare a materialized view based on any query, but there needs to be a unification rule to rewrite your query onto that view. (That is, rewrite your query using semantics-preserving algebraic transformations such that one branch of the rewritten query is identical to the query that defines the materialized view. See http://www.slideshare.net/julianhyde/calcite-algebraedw2015 <http://www.slideshare.net/julianhyde/calcite-algebraedw2015> slides 15+.) There are unification rules for scan, filter, project and some kinds of aggregation, but not join. Knowing how difficult it was to write unification rules, and knowing how common was the use case of star queries (scan - filter - join - aggregate), I invented lattices. First you define a lattice (a collection of tables joined using many-to-one relationships), then you (or the system) defines materialized views on top of that lattice. If an incoming query uses tables from that lattice, joined using the same join keys, then Calcite will consider substituting any materialized views in that lattice. Matching queries to lattice materialized views is much more efficient than matching to general purpose materialized views, two reasons. (a) The joins are removed, the materialized view and the query become just projects of the lattice’s columns, and we avoid the combinatorial explosion that occurs when joins are permuted. (b) A lattice can contain dozens of materialized views but it is clear, because they are partially ordered, which is the best for a given query, and they are all considered at the same time. Julian > On Jun 5, 2016, at 18:58, [email protected] wrote: > > AFAIK it doesn't. Not sure if some work has been done towards it. > Sent from my iPhone > >> On 06-Jun-2016, at 7:08 AM, Michael Mior <[email protected]> wrote: >> >> Am I correct in understanding that Calcite doesn't currently rewrite >> queries to use materialized views if the query which defines the view >> includes a join? If this is the case, has there been any work towards >> making this happen? >> >> -- >> Michael Mior >> [email protected]
