Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-11210

SQL: Introduce common logical execution plan for all query types

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.8
    • sql
    • None

    Description

      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:

      1. Two-step plan
      2. DML plan
      3. Partition pruning stuff
      4. May be even cached physical node distribution (for reduce queries) for the given AffinityTopologyVersion
      5. 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.

      Attachments

        Issue Links

          Activity

            People

              vozerov Vladimir Ozerov
              vozerov Vladimir Ozerov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m