QSM-02200: PCT FAST REFRESH is not possible if query contains LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN

QSM-02200: PCT FAST REFRESH is not possible if query contains LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN
Cause: The capability in question was not supported because the materialized view query contained LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN.
Action: Rephrase the query to avoid the use of LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02200：如果查询包含LEFT OUTER，RIGHT OUTER或FULL OUTER JOIN，则无法进行快速刷新,
.原因：不支持该问题的能力，因为物化视图查询包含LEFT OUTER，RIGHT OUTER或FULL OUTER JOIN。,
.操作：重新执行查询以避免使用LEFT OUTER，RIGHT OUTER或FULL OUTER JOIN。,
.

aiaiDBA

13718043309

010-86462881

QSM-02200: PCT FAST REFRESH is not possible if query contains LEFT OUTER, RIGHT OUTER or FULL OUTER JOIN

1 个回答

相似问题