[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-17429:
--------------------------------------
Description:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [IF NOT EXISTS] name ON table_name [USING { HASH | TREE }]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
was:
We need to give an ability to manage index via DDL statements.
As a first step lets support CREATE and DROP statements only. Within this
ticket we need to extend the sql grammar file as well as provide all necessary
structures to keep parsed AST.
The proposed grammar:
{code:java}
CREATE INDEX [IF NOT EXISTS] name ON table_name [USING HASH | SORTED ]
(column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
{code}
{code:java}
DROP INDEX [IF EXISTS] name;{code}
> Sql. Extend sql grammar to support CREATE/DROP INDEX statements
> ---------------------------------------------------------------
>
> Key: IGNITE-17429
> URL: https://issues.apache.org/jira/browse/IGNITE-17429
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> We need to give an ability to manage index via DDL statements.
> As a first step lets support CREATE and DROP statements only. Within this
> ticket we need to extend the sql grammar file as well as provide all
> necessary structures to keep parsed AST.
> The proposed grammar:
> {code:java}
> CREATE INDEX [IF NOT EXISTS] name ON table_name [USING { HASH | TREE }]
> (column_name [ASC | DESC] [NULLS {FIRST | LAST}] [, ...]);
>
> {code}
> {code:java}
> DROP INDEX [IF EXISTS] name;{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
