aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function

QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function
Cause: The capability in question is not supported when the materialized view uses the DISTINCT clause in this context.
Action: Re-phrase the query to avoid the use of the DISTINCT clause.

请先 登录 后评论

1 个回答

小智
QSM-02084:重复敏感聚合函数的DISTINCT子句,
.原因:当物化视图在此上下文中使用DISTINCT子句时,不支持该问题的功能。,
.操作:重新排序查询以避免使用DISTINCT子句。,
.
请先 登录 后评论