Help Center/ GaussDB(DWS)/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ CREATE EXCEPT RULE
Updated on 2025-07-22 GMT+08:00
View PDF
Share

CREATE EXCEPT RULE

Function

This syntax is used to create an exception rule set. When creating an exception rule, you can specify the rule thresholds and operations following the triggering of an exception rule. Currently, only the abort operation is supported.

Precautions

None

Syntax

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
 
CREATE 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 CREATE EXCEPT RULE parameters

Parameter

Description

Value Range

rule_name

Name of an exception rule set.

A string, which must comply with Identifier Naming Conventions.

blocktime

Maximum duration of job queue blocking, in seconds.

Numeric type. The value can be -1 or ranges from 1 to INT64_MAX. Set the value to -1, which indicates that the value is not limited.

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. The unit is second.

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

cpuskewpercent

Average CPU usage during job execution. The unit is percentage.

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

cpuavgpercent

CPU usage skew during job execution. The unit is 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. The unit is MB.

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

broadcastsize

Maximum broadcast size of a job. The unit is MB.

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

memsize

Maximum memory size used for job execution. Unit: MB.

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

bandwidth

Maximum bandwidth that can be used for job execution. Unit: MB.

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

Examples

Create exception rule set except_rule1 and set the blocktime threshold to 3000 seconds, and spilling space to 4000 MB.

1
 
CREATE EXCEPT RULE except_rule1 WITH (blocktime=3000, spillsize=4000, action=abort);

Create an exception rule set except_rule2 and set the memsize threshold to 5000 MB. The default operation following an exception is abort.

1
 
CREATE EXCEPT RULE except_rule2 WITH (memsize=3000);

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

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

Helpful Links

ALTER EXCEPT RULE, DROP EXCEPT RULE

Parent Topic: DDL Syntax