QSM-02198: PCT FAST REFRESH is not possible if HAVING clause includes a subquery

QSM-02198: PCT FAST REFRESH is not possible if HAVING clause includes a subquery
Cause: The capability in question was not supported because the materialized view query HAVING clause included a subquery.
Action: Rephrase the query to avoid the use of a subquery in the HAVING clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02198：如果HAVING子句包含子查询，则不能进行PCT快速刷新,
.原因：由于实例化视图查询HAVING子句包含子查询，因此不支持该问题的能力。,
.操作：重新执行查询以避免在HAVING子句中使用子查询。,
.

aiaiDBA

13718043309

010-86462881

QSM-02198: PCT FAST REFRESH is not possible if HAVING clause includes a subquery

1 个回答

相似问题