[IGNITE-18254] Sql. Extend SQL grammar with ALTER ZONE statement

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0-beta1
• Fix Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: ignite-3
• Epic Link: Distribution Zones [Part1]
• Ignite Flags: Docs Required
• Assignee: Maksim Zhuravkov
• Reporter: Iurii Gerzhedovich
• Created: 24/Nov/22 15:18
• Updated: 20/Jan/23 06:32
• Resolved: 20/Jan/23 06:32

Description

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:

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
]

So, could be changed any distributed zone parameters except PARTITIONS and AFFINITY_FUNCTION

Issue Links

• is a child of: IGNITE-18158 Sql. Investigate possible syntax and abilities for ALTER ZONE command
• links to: GitHub Pull Request #1521
• links to: https://github.com/apache/ignite-3/pull/1521