Konstantin Orlov created IGNITE-17655: -----------------------------------------
Summary: Sql. Provide integration for index scan Key: IGNITE-17655 URL: https://issues.apache.org/jira/browse/IGNITE-17655 Project: Ignite Issue Type: Improvement Components: sql Reporter: Konstantin Orlov After IGNITE-17431 indexes became a part of query plan. So, now we need to provide appropriate runtime to make an execution of index scans possible. Integration points for sql engine will be interface org.apache.ignite.internal.index.Index and derived org.apache.ignite.internal.index.SortedIndex. A few changes is required to those interfaces though: the {{scan}} methods should be reworked in the following way: {code:java} // for Index.java scan should look like this one Publisher<BinaryTuple> scan(int partId, @Nullable InternalTransaction tx, BinaryTuple key, BitSet columnsToInclude) // for SortedIndex.java range scan should look like this Publisher<BinaryTuple> scan(int partId, @Nullable InternalTransaction tx, BinaryTuple leftBound, BinaryTuple rightBound, int flags, BitSet columnsToInclude) {code} Besides, we need to reconsider the way we work with an index conditions. Currently we stick with Ignite-2 way, where search row is represented by a tuple of the same size as table row, but only indexed columns is set to a particular values while others are set to null. For example for table (id, project_id, command_id, name) and index (command_id, project_id) a search tuple looks like (null, <project_id_condition>, <command_id_condition>, null). We need to rework this in a way to make a search tuple match the actual order of indexed columns. With that said, the search tuple for the example above should look like (<command_id_condition>, <project_id_condition>). Finally, since both table and index scan have the very similar API, it seems reasonable to rework {{org.apache.ignite.internal.sql.engine.exec.rel.TableScanNode}} in a way to cover both cases (table scan and index scan). -- This message was sent by Atlassian Jira (v8.20.10#820010)