You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Maksim Zhuravkov (Jira)" <ji...@apache.org> on 2023/01/11 12:59:00 UTC

[jira] [Assigned] (IGNITE-18254) Sql. Extend SQL grammar with ALTER ZONE statement

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

Maksim Zhuravkov reassigned IGNITE-18254:
-----------------------------------------

    Assignee: Maksim Zhuravkov

> Sql. Extend SQL grammar with ALTER ZONE statement
> -------------------------------------------------
>
>                 Key: IGNITE-18254
>                 URL: https://issues.apache.org/jira/browse/IGNITE-18254
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Yury Gerzhedovich
>            Assignee: Maksim Zhuravkov
>            Priority: Major
>              Labels: ignite-3
>
> As we can CREATE and DROP ZONE need to provide ability to altering a distribution zones by DDL commands.
> Let's extend SQL grammar with following syntax:
> {code:java}
> ALTER ZONE {fq_zone_name | simple_zone_name} RENAME TO {fq_new_zone_name} [;]
> ALTER ZONE
>     { fq_zone_name | simple_zone_name }
>     WITH
>         [<data_nodes_auto_adjust>],
>         [DATA_NODES_FILTER = filter],
>         [REPLICAS = replicas],    
> [;]
>  
> <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}
> So, could be changed any distributed zone parameters except PARTITIONS and AFFINITY_FUNCTION



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