[HUDI-3881] Implement index syntax for spark sql

• Type: New Feature
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Component/s: spark-sql
• Labels: pull-request-available
• Assignee: Forward Xu
• Reporter: Forward Xu
• Created: 14/Apr/22 11:10
• Updated: 29/Mar/23 10:45
• Resolved: 29/Mar/23 10:45

Description

1. Create Index
CREATE INDEX [IF NOT EXISTS] index_name
ON [TABLE] [db_name.]table_name (column_name [ASC|DESC], ...) 
USING [bloom/lucene]
[PROPERTIES ('key'='value')] 

2. Refresh Index
REFRESH INDEX index_name ON [TABLE] [db_name.]table_name

3. Drop Index 
DROP INDEX [IF EXISTS] index_name ON [TABLE] [db_name.]table_name

4. Show index
SHOW INDEX [index_name] ON [TABLE] [db_name.]table_name

Issue Links

• links to: GitHub Pull Request #5339