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

Calcite engine. Fallback to table scan if index is absent on some nodes

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Calcite-based SQL engine creates a plan on node initiator and uses only local node data for planning. The local node doesn't know about other nodes' indexes state, indexes on some nodes can be rebuilt during query execution, and fragments of the plan containing rebuilding indexes can't be executed on these nodes. In this case, we should provide some type of fallback. For example, if the status of the index is invalid and the plan contains an index scan, we should replace this index scan with the chain: sorted index spool -> sort -> table scan.
      As a target solution, perhaps we should maintain global indexes state and make plans using this information

      Attachments

        Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-15436 Calcite engine. Merge Calcite SQL Engine to Ignite 2.x

          • Major - Major loss of function.
          • Resolved
          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-13035 Calcite integration. Support fallback on indexes rebuild

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is part of

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-12248 Apache Calcite based query execution engine

          • Major - Major loss of function.
          • Open
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-16507 Calcite engine. Redundant sort node when rewriting index scan on index rebuild

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          links to

          Web Link GitHub Pull Request #9671

          Activity

            People

              alex_pl Aleksey Plekhanov
              alex_pl Aleksey Plekhanov
              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 - 5h 10m
                  5h 10m