You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "jhonye (Jira)" <ji...@apache.org> on 2023/03/27 08:40:00 UTC
[jira] [Commented] (CALCITE-5513) Add Support Use Sql to recommend Materialized View
[ 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)