You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yury Gerzhedovich (Jira)" <ji...@apache.org> on 2022/12/21 11:27:00 UTC
[jira] [Updated] (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 ]
Yury Gerzhedovich updated IGNITE-18254:
---------------------------------------
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:
{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
was:
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],
[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
> 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
> 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)