Skip to main content

CANCEL MATERIALIZED VIEW TASK

Description​

This statement is used to cancel the task of materialized views

syntax:

CANCEL MATERIALIZED VIEW TASK taskId=INTEGER_VALUE ON mvName=multipartIdentifier

Examples​

  1. Cancel the task with id 1 in materialized view mv1

    CANCEL MATERIALIZED VIEW TASK 1 on mv1;

Keywords​

CANCEL, MATERIALIZED, VIEW, TASK

Best Practice​