SYSTEM RESUME

SYSTEM RESUME MATERIALIZED VIEW

SYSTEM RESUME MATERIALIZED VIEW <mv> [PERMANENT]

Materialized views are long-running queries. In some cases, you may want to pause the query so that no more data is sent to the downstream, then resume the materialized view later. Please avoid restarting the server when the materialized view is paused.

PERMANENT (Optional) - Resumes the view persistently so it remains running after a service restart; without it, the resume is temporary and any previous permanent pause state will be restored on restart.

This command is only available in Timeplus Enterprise v2.7.0 or above. In earlier versions, you can use SYSTEM UNPAUSE MATERIALIZED VIEW to resume the materialized view.

SYSTEM RESUME TASK

SYSTEM RESUME TASK task;