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

[Yury Gerzhedovich (Jira)]

Yury Gerzhedovich created IGNITE-18254:
------------------------------------------

             Summary: Sql. Extend SQL grammar with ALTER ZONE statement
                 Key: IGNITE-18254
                 URL: https://issues.apache.org/jira/browse/IGNITE-18254
             Project: Ignite
          Issue Type: Sub-task
          Components: sql
            Reporter: Yury Gerzhedovich


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 }
    WITH
        [
            <data_nodes_auto_adjust> |
            DATA_NODES_FILTER filter |
            (<data_nodes_auto_adjust>, DATA_NODES_FILTER filter)
        ]    
[;]
 
<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 all parameters except PARTITIONS, REPLICAS, 
AFFINITY_FUNCTION




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