SHOW SQL_BLOCK_RULE
Description
Displays the configured SQL blocking rules. If no rule name is specified, all rules will be displayed.
Syntax
SHOW SQL_BLOCK_RULE [FOR <rule_name>];
Optional Parameters
<rule_name>
The name of the SQL blocking rule to display. If omitted, all rules will be shown. |
Access Control Requirements
Users executing this command must have the following privileges:
| Privilege | Object | Notes |
|---|---|---|
ADMIN | User or Role | Required to perform this operation. |
Examples
- Display all SQL blocking rules
SHOW SQL_BLOCK_RULE;
+------------+------------------------------+---------+-------------+-----------+-------------+--------+--------+------------------------+
| Name | Sql | SqlHash | PartitionNum | TabletNum | Cardinality | Global | Enable | RequirePartitionFilter |
+------------+------------------------------+---------+-------------+-----------+-------------+--------+--------+------------------------+
| test_rule | select * from order_analysis | NULL | 0 | 0 | 0 | true | true | false |
| test_rule2 | NULL | NULL | 30 | 0 | 10000000000 | false | true | false |
+------------+------------------------------+---------+-------------+-----------+-------------+--------+--------+------------------------+
- Display a specific SQL blocking rule
SHOW SQL_BLOCK_RULE FOR test_rule2;
+------------+------+---------+-------------+-----------+-------------+--------+--------+------------------------+
| Name | Sql | SqlHash | PartitionNum | TabletNum | Cardinality | Global | Enable | RequirePartitionFilter |
+------------+------+---------+-------------+-----------+-------------+--------+--------+------------------------+
| test_rule2 | NULL | NULL | 30 | 0 | 10000000000 | false | true | false |
+------------+------+---------+-------------+-----------+-------------+--------+--------+------------------------+
