Materialized views with JOINs when Answer Query? #1348

Hi, @IPetrov2013

Thank you for your inquiry.
Supporting multi-relations—including joins and Cartesian products—is a key part of the AQUMV roadmap.

Our approach to this feature is structured in two primary phases:

1. Materialized View Maintenance:
   The foundational catalog design already incorporates the necessary structures for multi-relations. If we decide to do that, the upcoming work will focus on developing the maintenance mechanisms for these views.

2. Automatic Query Rewrite:
   This phase presents a more significant technical challenge. It requires developing an algorithm capable of rewriting user queries with complex multi-relation logic to utilize the materialized views correctly.

We fully recognize the importance of this capability. However, this is not easy.
I think our development strategy will be to incrementally add support, beginning with simpler constructs like self-joins, followed by inner joins, and then expanding to outer joins and other complex operations.

We appreciate your feedback and will provide further updates as development progresses.