QSM-02014: GROUP BY expression other than a column

QSM-02014: GROUP BY expression other than a column
Cause: The capability in question is not supported when the materialized view uses an expression other than a simple column reference in the GROUP BY clause.
Action: Re-phrase the query to use only simple column expressions in the GROUP BY clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02014：除列之外的GROUP BY表达式,
.原因：当物质化视图使用GROUP BY子句中的简单列引用以外的表达式时，不支持该问题的能力。,
.操作：重新排序查询以在GROUP BY子句中仅使用简单的列表达式。,
.

aiaiDBA

13718043309

010-86462881

QSM-02014: GROUP BY expression other than a column

1 个回答

相似问题