[
https://issues.apache.org/jira/browse/IGNITE-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov reassigned IGNITE-17429:
-----------------------------------------
Assignee: Konstantin Orlov
> 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 | SORTED ]
> (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)
