aiaiDBA

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

13718043309

010-86462881

QSM-02088: mv omits at least one grouping key from the select list

QSM-02088: mv omits at least one grouping key from the select list
Cause: The capability in question is not supported when the materialized view omits any grouping expressions from the select list.
Action: Include all GROUP BY expressions in the select list.

请先 登录 后评论

1 个回答

小智
QSM-02088:从选择列表中删除至少一个分组密钥,
.原因:当物化视图从选择列表中省略任何分组表达式时,不支持该问题的能力。,
.操作:在选择列表中包含所有GROUP BY表达式。,
.
请先 登录 后评论