ALTER WAREHOUSE

Introduced or updated: v1.2.687

动态调整计算集群的配置，包括添加/删除集群、重命名集群和分配/取消分配节点。

Syntax

ALTER WAREHOUSE <warehouse_name>
    [ADD CLUSTER <cluster_name> [WITH CLUSTER_SIZE = <size>] | (ASSIGN <node_count> NODES FROM <node_group>) ]
  | [RENAME CLUSTER <old_cluster_name> TO <new_cluster_name>]
  | [DROP CLUSTER <cluster_name>]
  | [ASSIGN NODES (ASSIGN <node_count> NODES [FROM <node_group>] FOR <cluster_name>)]
  | [UNASSIGN NODES (UNASSIGN <node_count> NODES [FROM <node_group>] FOR <cluster_name>)]

Examples

此示例向现有计算集群添加集群：

ALTER WAREHOUSE test_warehouse ADD CLUSTER test_cluster WITH CLUSTER_SIZE = 3;

此示例重命名现有集群：

ALTER WAREHOUSE test_warehouse RENAME CLUSTER default TO test_cluster_2;

此示例删除现有集群：

ALTER WAREHOUSE test_warehouse DROP CLUSTER test_cluster_2;

此示例向现有计算集群添加节点：

ALTER WAREHOUSE test_warehouse ASSIGN NODES (ASSIGN 2 NODES FOR test_cluster);

此示例从现有计算集群中删除节点：

ALTER WAREHOUSE test_warehouse UNASSIGN NODES (UNASSIGN 1 NODES FOR test_cluster);

此示例通过从特定节点组中选择节点来创建集群：

ALTER WAREHOUSE test_warehouse ADD CLUSTER test_cluster (ASSIGN 1 NODES FROM dev_node, ASSIGN 1 NODES FROM infra_node);

此示例将特定节点组中的节点添加到现有计算集群：

ALTER WAREHOUSE test_warehouse ASSIGN NODES (ASSIGN 1 NODES FROM dev_node FOR default, ASSIGN 1 NODES FROM infra_node FOR default);

此示例删除计算集群中特定节点组中的节点：

ALTER WAREHOUSE test_warehouse UNASSIGN NODES (UNASSIGN 1 NODES FROM dev_node FOR default, UNASSIGN 2 NODES FROM infra_node FOR default);