You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Pereslegin (Jira)" <ji...@apache.org> on 2022/11/21 15:19:00 UTC

[jira] [Assigned] (IGNITE-18156) Sql. Extend SQL grammar with CREATE/DROP ZONE statement

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

Pavel Pereslegin reassigned IGNITE-18156:
-----------------------------------------

    Assignee: Pavel Pereslegin

> Sql. Extend SQL grammar with CREATE/DROP ZONE statement
> -------------------------------------------------------
>
>                 Key: IGNITE-18156
>                 URL: https://issues.apache.org/jira/browse/IGNITE-18156
>             Project: Ignite
>          Issue Type: Sub-task
>          Components: sql
>            Reporter: Yury Gerzhedovich
>            Assignee: Pavel Pereslegin
>            Priority: Major
>              Labels: ignite-3
>             Fix For: 3.0.0-beta2
>
>
> We need to provide an ability to configure distribution zones  by DDL commands.
> Let's extend SQL grammar with following syntax:
> {code:java}
> CREATE ZONE
>     { fq_zone_name | simple_zone_name }
>     [WITH
>         [
>             <data_nodes_auto_adjust> |
>             DATA_NODES_FILTER filter |
>             (<data_nodes_auto_adjust>, DATA_NODES_FILTER filter)
>         ],
>         [PARTITIONS = partitions],
>         [REPLICAS = replicas],
>         [AFFINITY_FUNCTION = function]
>     ]
> [;]
>  
> <data_nodes_auto_adjust> ::= [
>     DATA_NODES_AUTO_ADJUST_SCALE_UP = scale_up_value |
>     DATA_NODES_AUTO_ADJUST_SCALE_DOWN = scale_down_value |
>     (DATA_NODES_AUTO_ADJUST_SCALE_UP = scale_up_value & DATA_NODES_AUTO_ADJUST_SCALE_DOWN = scale_down_value) | DATA_NODES_AUTO_ADJUST  = auto_adjust_value
> ]{code}
> {code:java}
> DROP ZONE {fq_zone_name | simple_zone_name}{code}
> As a result the parser should be able to parse mentioned statements and provide a valid AST representing those statements.



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