Materialized views with JOINs when Answer Query?

[IPetrov2013]

Hi,

The Answer Query feature for single tables is great. Are there any plans to make it work for queries with JOINs? Most of our queries have joins, so that would be a huge help.

Thanks.

[avamingli]

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.

[IPetrov2013]

Thanks, most of our cases have left joins or inner joins.

[avamingli]

Good to know, it's reassuring to see your needs align with our technical roadmap.

[IPetrov2013]

Hi, @avamingli Do you have any progress update or a rough timeline for this?

[avamingli]

Hi, I'm currently busy with work and haven't had a chance to start on this yet. I will provide an update as soon as I have one. Thanks for your patience.

[IPetrov2013]

Ping :)

[cuiX701]

Looking forward to this feature as well.