[IGNITE-21278] Add FORCE_INDEX/NO_INDEX hints for calcite engine

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Epic Link: Criteria API queries
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Andrey Novikov
• Reporter: Andrey Novikov
• Reviewer: Andrey Mashenkov
• Created: 17/Jan/24 07:27
• Updated: 04/Sep/24 16:07
• Resolved: 01/Feb/24 03:35

Description

As part of hints for Calcite, we could try to implement simple hint like FORCE_INDEX/NO_INDEX.

As reference ignite 2.x documentation can be used https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index

Issue Links

• Blocked: IGNITE-20881 Add ability to enforce an index to be used
• is related to: IGNITE-21416 Add documentation for FORCE_INDEX/NO_INDEX hints
• Testing discovered: IGNITE-21404 Do not wrap SqlException into RuntimeException for PlannerHelper.optimize
• links to: GitHub Pull Request #3071