[ https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Forward Xu updated HUDI-3881: ----------------------------- Description: {code:java} 1. CREATE INDEX CREATE INDEX [IF NOT EXISTS] index_name ON [TABLE] [db_name.]table_name (column_name, ...) AS bloomfilter/lucene [WITH DEFERRED REFRESH] [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 INDEXES ON [TABLE] [db_name.]table_name{code} was: {code:java} 1.create index CREATE INDEX [IF NOT EXISTS] index_name ON TABLE [db_name.]table_name (column_name, ...) AS bloomfilter/lucene [WITH DEFERRED REFRESH] [PROPERTIES ('key'='value')] {code} > Implement index syntax for spark sql > ------------------------------------ > > Key: HUDI-3881 > URL: https://issues.apache.org/jira/browse/HUDI-3881 > Project: Apache Hudi > Issue Type: New Feature > Components: spark-sql > Reporter: Forward Xu > Assignee: Forward Xu > Priority: Major > > {code:java} > 1. CREATE INDEX > CREATE INDEX [IF NOT EXISTS] index_name > ON [TABLE] [db_name.]table_name (column_name, ...) > AS bloomfilter/lucene > [WITH DEFERRED REFRESH] > [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 INDEXES ON [TABLE] [db_name.]table_name{code} -- This message was sent by Atlassian Jira (v8.20.1#820001)