[IGNITE-14306] Sql. Hint ENFORCE JOIN ORDER support

• Type: Improvement
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: calcite2-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Iurii Gerzhedovich
• Reporter: Iurii Gerzhedovich
• Created: 12/Mar/21 07:43
• Updated: 08/May/23 09:51
• Resolved: 08/May/23 09:51

Description

We need to introduce hints for the new SQL engine.
At least it could be planner hints, like an ENFORCE JOIN ORDER, Algorithm of join, switch on/off some planer rules. Maybe we could pass as a hint the whole execution plan, or modify some parameters, like costs.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #1982
• links to: PR #1982