QSM-02004: grouping column omitted from SELECT list

QSM-02004: grouping column omitted from SELECT list
Cause: The capability in question is not supported when the materialized view contains a column or expression in the GROUP BY clause that is not also present in the list of output select expressions.
Action: Include all GROUP BY expressions in the output select list.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02004：从列表中省略分组列,
.原因：当物化视图包含GROUP BY子句中不存在于输出选择表达式列表中的列或表达式时，不支持该问题的能力。,
.操作：在输出选择列表中包含所有GROUP BY表达式。,
.

aiaiDBA

13718043309

010-86462881

QSM-02004: grouping column omitted from SELECT list

1 个回答

相似问题