Aleksey Plekhanov created IGNITE-16111:
------------------------------------------
Summary: Calcite engine. Fallback to table scan if index is absent
on some nodes
Key: IGNITE-16111
URL: https://issues.apache.org/jira/browse/IGNITE-16111
Project: Ignite
Issue Type: Improvement
Reporter: Aleksey Plekhanov
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
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
