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

["Vladimir Ozerov (JIRA)" <ji...@apache.org>]

Vladimir Ozerov created IGNITE-11210:
----------------------------------------

             Summary: 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


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)