QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility

QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility
Cause: The capability in question is not supported when the materialized view has no GROUP BY clause, no aggregates and compatibility mode is less than 9.0.
Action: Re-phrase the query to avoid the include a GROUP BY clause or an aggregate function. Or set compatibility mode to 9.0 or greater.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02114：没有GROUP BY子句，没有聚合而不是= = 9.0兼容性,
.原因：当物化视图没有GROUP BY子句时，不支持该问题的能力，没有聚合和兼容性模式小于9.0。,
.操作：重新排序查询以避免包含GROUP BY子句或聚合函数。或将兼容性模式设置为9.0或更高版本。,
.

aiaiDBA

13718043309

010-86462881

QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility

1 个回答

相似问题