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

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

Yury Gerzhedovich created IGNITE-18156:
------------------------------------------

             Summary: 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: Improvement
          Components: sql
            Reporter: Yury Gerzhedovich


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
]


{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)