ALTER MATERIALIZED VIEW STATUS
Syntax
ALTER MATERIALIZED VIEW qualifiedName SET STATUS <status>
Description
Modify the status of materialized views. Only materialized views in the ENABLED or SUSPEND state can be modified. The statuses of materialized views include:
- INIT: The materialized view is created for the first time.
- SUSPEND: The materialized view is suspended. The suspended materialized view is not rewritten.
- ENABLED: The materialized view is available.
- REFRESHING: The materialized view data is being refreshed and cannot be rewritten.
- DISABLED: The materialized view has been disabled.
Example
Change the status of mv.default.mv1 to SUSPEND.
alter materialized view mv.default.mv1 set status SUSPEND;
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot