[jira] [Updated] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-03-27 Thread jhonye (Jira)


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


[jira] [Updated] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-02-03 Thread Julian Hyde (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Hyde updated CALCITE-5513:
-
Language:   (was: JAVA)

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


[jira] [Updated] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-02-03 Thread jhonye (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

jhonye updated CALCITE-5513:

Description: 
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.)

 

  was:
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, Please assign to 
@jhonye.)

 


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


[jira] [Updated] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-02-03 Thread Stamatis Zampetakis (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stamatis Zampetakis updated CALCITE-5513:
-
Fix Version/s: (was: 1.33.0)

> 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
>   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, Please assign to 
> @jhonye.)
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-02-02 Thread jhonye (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

jhonye updated CALCITE-5513:

Description: 
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, Please assign to 
@jhonye.)

 

  was:
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, Please assign to me.)

 


> 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
>Priority: Major
> Fix For: 1.33.0
>
>   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, Please assign to 
> @jhonye.)
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (CALCITE-5513) Add Support Use Sql to recommend Materialized View

2023-02-02 Thread jhonye (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-5513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

jhonye updated CALCITE-5513:

Description: 
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, Please assign to me.)

 

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

 


> 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
>Priority: Major
> Fix For: 1.33.0
>
>   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, Please assign to 
> me.)
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)