You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Roman Kondakov (Jira)" <ji...@apache.org> on 2020/02/21 14:57:00 UTC

[jira] [Created] (IGNITE-12715) Calcite integration. Secondary indexes support.

Roman Kondakov created IGNITE-12715:
---------------------------------------

             Summary: Calcite integration. Secondary indexes support.
                 Key: IGNITE-12715
                 URL: https://issues.apache.org/jira/browse/IGNITE-12715
             Project: Ignite
          Issue Type: New Feature
          Components: sql
            Reporter: Roman Kondakov


Secondary indexes should be supported by Calcite-based engine as well as they supported by the legacy H2 engine. At first we can use the old engine for indexes maintenance (building, updating, etc). In this case Calcite engine will only use indexes metadata for query planning and index scans for query execution. On the next iteration we need to eliminate the old engine usage.

Approximate plan for indexes support implementation:
 # Add indexes to schema and set up all schema listeners.
 # Add Collation to planner's output trait set and check if generated plan is properly chosen in accordance to index sort direction.
 # Implement index scans with filtering
 # Add Sort node to exec. 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)