[HUDI-7700] Support query hint to inject indexes in query plans

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 1.1.0
• Labels: hudi-1.0.0-beta2
• Story Points: 6
• Epic Link: secondary index
• Assignee: Sagar Sumit
• Reporter: Sagar Sumit
• Created: 02/May/24 00:10
• Updated: 24/Jul/24 07:22

Description

Hints give users a way to suggest how SQL to use specific approaches to generate its execution plan. Simply creating the index, such as functional index or secondary index, does not necessarily ensure its usage in the query planning. While we have hierarchy of index to use in `HoodieFileIndex`, we want a way for users to provide explicitly to use some specific index (for instantance during index join) to use while planning.