[
https://issues.apache.org/jira/browse/HUDI-4165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
shibei resolved HUDI-4165.
--------------------------
> Support Create/Drop/Show/Refresh Index Syntax for Spark SQL
> -----------------------------------------------------------
>
> Key: HUDI-4165
> URL: https://issues.apache.org/jira/browse/HUDI-4165
> Project: Apache Hudi
> Issue Type: New Feature
> Reporter: shibei
> Assignee: shibei
> Priority: Major
> Labels: pull-request-available
>
> Support Create/Drop/Show/Refresh Index Syntax for Spark SQL, SQL Syntax:
> {code:java}
> -- Create Index
> CREATE INDEX [IF NOT EXISTS] index_name ON [TABLE] table_name
> [USING index_type]
> (column_name1 [OPTIONS(key1=value1, key2=value2, ...)], column_name2
> [OPTIONS(key1=value1, key2=value2, ...)], ...)
> [OPTIONS (key1=value1, key2=value2, ...)]
> -- Drop Index
> DROP INDEX [IF EXISTS] index_name ON [TABLE] table_name
> -- Show Indexes
> SHOW INDEXES {FROM | IN} [TABLE] table_name
> -- Refresh Index
> REFRESH INDEX index_name ON [TABLE] table_name{code}
>
> Notice:
> * Create/Drop Index Syntax are forked from Spark 3.3.0-rc3,
> [https://github.com/apache/spark/blob/branch-3.3/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBaseParser.g4]
>
> Reference：
> - Hive sql index syntax：
> --
> [https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/AlterIndex]
>
> - MySQL index syntax：
> -- [https://dev.mysql.com/doc/refman/8.0/en/create-index.html]
> -- [https://dev.mysql.com/doc/refman/8.0/en/show-index.html]
> -- [https://dev.mysql.com/doc/refman/8.0/en/drop-index.html]
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
