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

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Done
• Fix Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Pavel Pereslegin
• Reporter: Iurii Gerzhedovich
• Created: 15/Nov/22 11:43
• Updated: 25/Nov/22 13:59
• Resolved: 25/Nov/22 13:59

Description

We need to provide an ability to configure distribution zones  by DDL commands.

Let's extend SQL grammar with following syntax:

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
]

DROP ZONE {fq_zone_name | simple_zone_name}

As a result the parser should be able to parse mentioned statements and provide a valid AST representing those statements.

Issue Links

• is required by: IGNITE-18157 Sql. Provide commands and handlers for distributed zones related operations
• links to: GitHub Pull Request #1372