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:31:00 UTC

[jira] [Updated] (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:all-tabpanel ]

jhonye updated CALCITE-5513:
----------------------------
    Attachment: image-2023-03-27-16-30-45-886.png

> 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)