Help Center/ Data Warehouse Service / SQL Syntax Reference (8.1.3.x)/ DDL Syntax/ ALTER EXCEPT RULE
Updated on 2025-06-12 GMT+08:00
View PDF

ALTER EXCEPT RULE

Function

This syntax modifies an exception rule set. You can modify one or more specific rule thresholds in a rule set.

Precautions

None

Syntax

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
 
ALTER EXCEPT RULE except_rule_name
      WITH (
           | BLOCKTIME = VALUE,
           | CPUTIME = VALUE,
           | ELAPSEDTIME = VALUE, 
           | CPUSKEWPERCENT = VALUE,
           | SPILLSIZE = VALUE,
           | BROADCASTSIZE = VALUE,
           | MEMSIZE = VALUE,
           | CPUAVGPERCENT = VALUE,
           | BANDWIDTH = VALUE,
           | ACTION = ['abort' | 'penalty']
           );

Parameter Description

Table 1 ALTER EXCEPT RULE parameters

Parameter

Description

Value Range

rule_name

Name of an exception rule set.

A string compliant with the identifier naming rules.

blocktime

Maximum duration of job queue blocking, in seconds.

Numeric type. The value can be –1 or ranges from 1 to INT64_MAX.

elapsedtime

Maximum job execution duration, in seconds.

Numeric type. The value can be –1 or ranges from 1 to INT64_MAX.

allcputime

Maximum CPU time used during job running, in seconds.

Numeric type. The value can be –1 or ranges from 1 to INT64_MAX.

cpuskewpercent

CPU usage skew during job execution, in percentage.

Numeric type. The value can be –1 or ranges from 1 to 100.

cpuavgpercent

Average CPU usage during job execution, in percentage.

Numeric type. The value can be –1 or ranges from 1 to 100.

spillsize

Maximum size of data spilled to disks during job execution, in MB.

Numeric type. The value can be –1 or ranges from 1 to INT64_MAX.

broadcastsize

Maximum broadcast size of a job, in MB.

Numeric type. The value can be –1 or ranges from 1 to INT64_MAX.

memsize

Maximum memory size used for job execution, in MB.

Numeric type. The value can be –1 or ranges from 1 to INT64_MAX.

bandwidth

Maximum network bandwidth that can be used for job execution, in MB.

Numeric type. The value can be –1 or ranges from 1 to INT64_MAX.

Examples

Create an exception rule except_rule1.

1
 
CREATE EXCEPT RULE except_rule_1 WITH (blocktime=2000, spillsize=3000, action=abort);

Change the blocktime threshold of exception rule set except_rule1 to 3000s and the space for spilled data to 4000 MB.

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

Create a resource pool and bind it to exception rule set except_rule_1.

1
 
CREATE resource pool resource_pool_a1 WITH (except_rule='except_rule_1');

Unbind the exception rule set from the resource pool resource_pool_a1.

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

Helpful Links

CREATE EXCEPT RULE and DROP EXCEPT RULE

Parent Topic: DDL Syntax