QSM-02175: some query block in UNION ALL MV is not fast refreshable

QSM-02175: some query block in UNION ALL MV is not fast refreshable
Cause: For a materialized view with UNION ALL to be fast refreshable, each query block must conform to a fast refreshable materialized join view or materialized aggregate view.
Action: Check each query block in the UNION ALL to ensure it is either a materialized view with joins or aggregates.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02175：UNION ALL MV中的一些查询块不能快速刷新,
.原因：对于具有UNION ALL的实例化视图可快速刷新，每个查询块必须符合快速可刷新的实例化连接视图或物化聚合视图。,
.操作：检查UNION ALL中的每个查询块，以确保它是具有连接或聚合的物化视图。,
.

aiaiDBA

13718043309

010-86462881

QSM-02175: some query block in UNION ALL MV is not fast refreshable

1 个回答

相似问题