[jira] [Updated] (IGNITE-11210) SQL: Introduce common logical execution plan for all query types

2019-02-28 Thread Vladimir Ozerov (JIRA)


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

Vladimir Ozerov updated IGNITE-11210:
-
Fix Version/s: 2.8

> SQL: Introduce common logical execution plan for all query types
> 
>
> Key: IGNITE-11210
> URL: https://issues.apache.org/jira/browse/IGNITE-11210
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Vladimir Ozerov
>Assignee: Vladimir Ozerov
>Priority: Major
> Fix For: 2.8
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> At the moment we have a lot of various cached stuff used for different SQL 
> types (prepared statements for local queries, two-step queries for 
> distributed queries, update plan for DML). 
> What we need instead of having multiple caches is to create common execution 
> plan for every query, which will hold both DML and SELECT stuff. Approximate 
> content of such a plan:
> # Two-step plan
> # DML plan 
> # Partition pruning stuff
> # May be even cached physical node distribution (for reduce queries) for the 
> given {{AffinityTopologyVersion}}
> # Probably {{AffinityTopologyVersion}}
> Then we will perform a single plan lookup/build per every query execution. In 
> future we will probably display these plans in SQL views.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (IGNITE-11210) SQL: Introduce common logical execution plan for all query types

2019-02-27 Thread Vladimir Ozerov (JIRA)


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

Vladimir Ozerov updated IGNITE-11210:
-
Ignite Flags:   (was: Docs Required)

> SQL: Introduce common logical execution plan for all query types
> 
>
> Key: IGNITE-11210
> URL: https://issues.apache.org/jira/browse/IGNITE-11210
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Vladimir Ozerov
>Assignee: Vladimir Ozerov
>Priority: Major
> Fix For: 2.8
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> At the moment we have a lot of various cached stuff used for different SQL 
> types (prepared statements for local queries, two-step queries for 
> distributed queries, update plan for DML). 
> What we need instead of having multiple caches is to create common execution 
> plan for every query, which will hold both DML and SELECT stuff. Approximate 
> content of such a plan:
> # Two-step plan
> # DML plan 
> # Partition pruning stuff
> # May be even cached physical node distribution (for reduce queries) for the 
> given {{AffinityTopologyVersion}}
> # Probably {{AffinityTopologyVersion}}
> Then we will perform a single plan lookup/build per every query execution. In 
> future we will probably display these plans in SQL views.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)