CANCEL MATERIALIZED VIEW TASK
Descriptionβ
This statement is used to cancel the task of materialized views
Syntaxβ
CANCEL MATERIALIZED VIEW TASK <task_id> ON <mv_name>
Required Parametersβ
1. <task_id>
Specifies the task id of materialized view.
2. <mv_name>
Specifies the materialized view name.
The materialized view name must start with a letter character (or any language character if unicode name support is enabled) and cannot contain spaces or special characters unless the entire materialized view name string is enclosed in backticks (e.g.,
My Object).The materialized view name cannot use reserved keywords.
For more details, see Reserved Keywords.
Access Control Requirementsβ
Users executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
| ALTER_PRIV | Materialized View | CANCEL is an ALTER operation on a materialized view |
Exampleβ
-
Cancel the task with id 1 in materialized view mv1
CANCEL MATERIALIZED VIEW TASK 1 on mv1;
