QSM-02201: PCT FAST REFRESH is not possible if there is a self join or self cartesian product in query

QSM-02201: PCT FAST REFRESH is not possible if there is a self join or self cartesian product in query
Cause: The capability in question was not supported because the materialized view query contained self join of self cartesian product in the query.
Action: Rephrase the query to avoid the use of self joins or self cartesian product in the query.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02201：如果在查询中存在自连接或自笛卡尔产品，则不能进行PCT快速刷新,
.原因：由于物化视图查询在查询中包含自笛卡尔产品的自身连接，所以不支持该功能。,
.操作：重新执行查询以避免在查询中使用自连接或自笛卡尔产品。,
.

aiaiDBA

13718043309

010-86462881

QSM-02201: PCT FAST REFRESH is not possible if there is a self join or self cartesian product in query

1 个回答

相似问题