QSM-02104: aggregate function in a filter condition in the HAVING clause

QSM-02104: aggregate function in a filter condition in the HAVING clause
Cause: The capability in question is not supported when the materialized view references an aggregate function in a filter condition in the HAVING clause.
Action: Re-phrase the query to avoid the use of aggregates in filter conditions in the HAVING clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02104：HAVING子句中过滤条件的聚合函数,
.原因：当物化视图引用HAVING子句中的过滤条件中的聚合函数时，不支持该问题的能力。,
.操作：重新排序查询以避免在HAVING子句中的过滤条件中使用聚合。,
.

aiaiDBA

13718043309

010-86462881

QSM-02104: aggregate function in a filter condition in the HAVING clause

1 个回答

相似问题