QSM-02206: PCT FAST REFRESH is not possible because this query join may produce extra duplicate rows

QSM-02206: PCT FAST REFRESH is not possible because this query join may produce extra duplicate rows
Cause: The capability in question was not supported because the materialized view contained a join condition that can result in duplicate rows in the materialized view.
Action: Rephrase the query to avoid the occurrence of duplicate rows in the materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02206：PCT快速刷新是不可能的，因为此查询连接可能会生成额外的重复行,
.原因：由于物化视图包含可能导致物化视图中的重复行的连接条件，所以不支持该功能。,
.操作：重新执行查询以避免在物化视图中发生重复的行。,
.

aiaiDBA

13718043309

010-86462881

QSM-02206: PCT FAST REFRESH is not possible because this query join may produce extra duplicate rows

1 个回答

相似问题