[ https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17705244#comment-17705244 ]
jhonye commented on CALCITE-5513: --------------------------------- Design doc: !image-2023-03-27-16-30-45-886.png|width=852,height=424! # Input sql # Parse the sql to SqlNode and validate it. # Convert SqlNode to RelNode. # Use the RBO & CBO rule to optimize the logical plan. # The recommend rule is run during the optimize logical plan,as MaterializedViewAggregateRecommendRule. # The recommend rule parse the logical plan, and recommend the Materialized Views which can rewrite the source SQL. # Some recommend materialized views may be merged. # Some recommend materialized views may be the same. # The recommend materialized views need to sort, and get topN to use. # output recommend materialized views . > Add Support Use Sql to recommend Materialized View > --------------------------------------------------- > > Key: CALCITE-5513 > URL: https://issues.apache.org/jira/browse/CALCITE-5513 > Project: Calcite > Issue Type: New Feature > Components: core > Affects Versions: 1.33.0 > Reporter: jhonye > Assignee: jhonye > Priority: Major > Attachments: image-2023-03-27-16-30-45-886.png > > Original Estimate: 504h > Remaining Estimate: 504h > > How to use: > Input: SQL > Output: SQL > > Calcite Core: > 1. In Volcano Plan and iterator to optimize the Logical Plan. > 2. A rule recognize the Logical Plan and recommend materialized view Logical > Plan list which can rewrite the origin Logical Plan . > 3. the recommend algorithm need to design. (already done.) > -- This message was sent by Atlassian Jira (v8.20.10#820010)