Re: Candidate materialized views from query history

2018-12-04 Thread Zoltan Haindrich
Hey Mark! Sounds like an interesting thing! I don't think its being explored right now... :) I think you might start with the following approaches: * you can get access to the PlanMapper which usually has a full list of operator stats/signatures these signatures are designed to be comparable;

Candidate materialized views from query history

2018-12-02 Thread mark pasterkamp
Dear all, For research purposes I have been looking into finding potential materialized views based on a given set of queries. For instance, if you have 2 queries joining table A and B, perhaps it would be advantageous to materialize said join and utilise Calcite's ability to rewrite queries to