数据仓库服务 GAUSSDB(DWS)-ALTER EXCEPT RULE:示例

时间:2024-11-28 17:39:00

示例

修改异常规则except_rule1的blocktime规则阈值为3000秒,下盘空间为4000MB。

1
ALTER EXCEPT RULE except_rule1 WITH (blocktime=3000, spillsize=4000);

修改异常规则except_rule2的下盘空间规则spillsize为5000MB。

1
ALTER EXCEPT RULE except_rule2 WITH (spillsize=5000);

修改资源池resource_pool_a1绑定的异常规则集为except_rule3。

1
ALTER resource pool resource_pool_a1 WITH (except_rule='except_rule3');

解除资源池resource_pool_a1绑定的异常规则集。

1
ALTER resource pool resource_pool_a1 WITH (except_rule='None');
support.huaweicloud.com/sqlreference-830-dws/dws_06_0280.html