You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudberry.apache.org by "IPetrov2013 (via GitHub)" <gi...@apache.org> on 2025/09/08 03:16:13 UTC
[D] Materialized views with JOINs when Answer Query? [cloudberry]
GitHub user IPetrov2013 created a discussion: Materialized views with JOINs when Answer Query?
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.
GitHub link: https://github.com/apache/cloudberry/discussions/1348
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "IPetrov2013 (via GitHub)" <gi...@apache.org>.
GitHub user IPetrov2013 added a comment to the discussion: Materialized views with JOINs when Answer Query?
Thanks, most of our cases have left joins or inner joins.
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-14346475
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "IPetrov2013 (via GitHub)" <gi...@apache.org>.
GitHub user IPetrov2013 added a comment to the discussion: Materialized views with JOINs when Answer Query?
Hi, It's been a while since there was an update, could anyone kindly share if this is still actively on the roadmap?
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-15550029
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "IPetrov2013 (via GitHub)" <gi...@apache.org>.
GitHub user IPetrov2013 added a comment to the discussion: Materialized views with JOINs when Answer Query?
Hi, @avamingli Do you have any progress update or a rough timeline for this?
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-14404758
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "cuimeiyu (via GitHub)" <gi...@apache.org>.
GitHub user cuimeiyu added a comment to the discussion: Materialized views with JOINs when Answer Query?
Looking forward to this feature as well.
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-14497355
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "avamingli (via GitHub)" <gi...@apache.org>.
GitHub user avamingli added a comment to the discussion: Materialized views with JOINs when Answer Query?
I'm personally very interested in the project, though I should note it's not currently within my primary work priorities. I'll do my best to contribute.
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-15614088
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "avamingli (via GitHub)" <gi...@apache.org>.
GitHub user avamingli added a comment to the discussion: Materialized views with JOINs when Answer Query?
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.
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-14337518
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "IPetrov2013 (via GitHub)" <gi...@apache.org>.
GitHub user IPetrov2013 added a comment to the discussion: Materialized views with JOINs when Answer Query?
Ping :)
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-14662751
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "avamingli (via GitHub)" <gi...@apache.org>.
GitHub user avamingli added a comment to the discussion: Materialized views with JOINs when Answer Query?
Good to know, it's reassuring to see your needs align with our technical roadmap.
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-14347996
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org
Re: [D] Materialized views with JOINs when Answer Query? [cloudberry]
Posted by "avamingli (via GitHub)" <gi...@apache.org>.
GitHub user avamingli added a comment to the discussion: Materialized views with JOINs when Answer Query?
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.
GitHub link: https://github.com/apache/cloudberry/discussions/1348#discussioncomment-14452112
----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@cloudberry.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: dev-help@cloudberry.apache.org