[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-10-01 Thread Zhaojing Yu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zhaojing Yu updated HUDI-3881:
--
Fix Version/s: 0.13.0
   (was: 0.12.1)

> 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: Critical
>  Labels: pull-request-available
> Fix For: 0.13.0
>
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-09-19 Thread Raymond Xu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Raymond Xu updated HUDI-3881:
-
Sprint:   (was: 2022/09/19)

> 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: Critical
>  Labels: pull-request-available
> Fix For: 0.12.1
>
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-09-04 Thread sivabalan narayanan (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

sivabalan narayanan updated HUDI-3881:
--
Sprint: 2022/09/19  (was: 2022/09/05)

> 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: Critical
>  Labels: pull-request-available
> Fix For: 0.12.1
>
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-08-20 Thread Raymond Xu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Raymond Xu updated HUDI-3881:
-
Sprint: 2022/09/05  (was: 2022/08/22)

> 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: Critical
>  Labels: pull-request-available
> Fix For: 0.12.1
>
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-08-16 Thread Sagar Sumit (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sagar Sumit updated HUDI-3881:
--
Fix Version/s: 0.12.1
   (was: 0.12.0)

> 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: Critical
>  Labels: pull-request-available
> Fix For: 0.12.1
>
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-05-09 Thread Raymond Xu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Raymond Xu updated HUDI-3881:
-
Epic Link:   (was: HUDI-1658)

> 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: Critical
>  Labels: pull-request-available
> Fix For: 0.12.0
>
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-05-09 Thread Raymond Xu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Raymond Xu updated HUDI-3881:
-
Fix Version/s: 0.12.0

> 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
>  Labels: pull-request-available
> Fix For: 0.12.0
>
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-05-09 Thread Raymond Xu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Raymond Xu updated HUDI-3881:
-
Priority: Critical  (was: Major)

> 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: Critical
>  Labels: pull-request-available
> Fix For: 0.12.0
>
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-17 Thread Forward Xu (Jira) 


 [ 
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 [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{code}

  was:
{code:java}
1. Create Index
CREATE INDEX [IF NOT EXISTS] index_name
ON [TABLE] [db_name.]table_name (column_name, ...) 
USING [bloomfilter/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{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
>  Labels: pull-request-available
>
> {code:java}
> 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{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-17 Thread Forward Xu (Jira) 


 [ 
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, ...) 
USING [bloomfilter/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{code}

  was:
{code:java}
1. CREATE INDEX
CREATE INDEX [IF NOT EXISTS] index_name
ON [TABLE] [db_name.]table_name (column_name, ...) 
USING [bloomfilter/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 ON [TABLE] [db_name.]table_name{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
>  Labels: pull-request-available
>
> {code:java}
> 1. Create Index
> CREATE INDEX [IF NOT EXISTS] index_name
> ON [TABLE] [db_name.]table_name (column_name, ...) 
> USING [bloomfilter/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{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-17 Thread ASF GitHub Bot (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ASF GitHub Bot updated HUDI-3881:
-
Labels: pull-request-available  (was: )

> 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
>  Labels: pull-request-available
>
> {code:java}
> 1. CREATE INDEX
> CREATE INDEX [IF NOT EXISTS] index_name
> ON [TABLE] [db_name.]table_name (column_name, ...) 
> USING [bloomfilter/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 ON [TABLE] [db_name.]table_name{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-17 Thread Forward Xu (Jira) 


 [ 
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, ...) 
USING [bloomfilter/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 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, ...) 
USING [bloomfilter/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 INDEXES ON [TABLE] [db_name.]table_name{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, ...) 
> USING [bloomfilter/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 ON [TABLE] [db_name.]table_name{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-17 Thread Forward Xu (Jira) 


 [ 
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, ...) 
USING [bloomfilter/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 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')] 

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}


> 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, ...) 
> USING [bloomfilter/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 INDEXES ON [TABLE] [db_name.]table_name{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-17 Thread Forward Xu (Jira) 


 [ 
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')] 

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}


> 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)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-17 Thread Forward Xu (Jira) 


 [ 
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)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-16 Thread Forward Xu (Jira) 


 [ 
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')] {code}

  was:
{code:java}
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')] {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-14 Thread Forward Xu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HUDI-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Forward Xu updated HUDI-3881:
-
Epic Link: HUDI-1658

> 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}
> // code placeholder
> 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}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (HUDI-3881) Implement index syntax for spark sql

2022-04-14 Thread Forward Xu (Jira) 


 [ 
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}
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}

  was:
{code:java}
// code placeholder
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}
> 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}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)