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-unsubscr...@cloudberry.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@cloudberry.apache.org For additional commands, e-mail: dev-h...@cloudberry.apache.org
