Description
Extend join/aggregate materialized rewriting rule to produce rewritings using Union operators, e.g., a given query could be partially answered from the MV (year = 2014) and from the query (not(year=2014)). If the MV is stored e.g. in Druid, this rewriting might be beneficial. As with the other rewritings, decision on whether to finally use the rewriting is cost-based.
Attachments
Issue Links
- is related to
-
CALCITE-1802 Add post-aggregation step for Union in materialized view rewriting
- Closed
- relates to
-
CALCITE-1731 Rewriting of queries using materialized views with joins and aggregates
- Closed