更新时间:2024-07-02 GMT+08:00
分享

ALTER MATERIALIZED VIEW

语法

ALTER MATERIALIZED VIEW QUALIFIEDNAME SET PROPERTIES PROPERTY_NAME=PROPERTY_VALUE;

描述

修改物化视图的属性,相关属性可以参考CREATE MATERIALIZED VIEW

示例

将“mv.default.mv1mv.mvtestprop.pepa_ss”的物化视图提交自动刷新任务的优先级“PROPERTIES”属性更新为“refresh_priority = 2”。

Alter materialized view mv.mvtestprop.pepa_ss set PROPERTIES refresh_priority = 2;

相关文档