QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)

QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)
Cause: The capability in question is not supported when the materialized view uses grouping sets but omits the relevant GROUPING_ID or GROUPING functions.
Action: Re-phrase the query to include the relevant GROUPING_ID or GROUPING functions.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02117：GROUP BY列上缺少GROUPING_ID或GROUPING函数,
.原因：当物化视图使用分组集但忽略相关的GROUPING_ID或GROUPING函数时，不支持该问题的能力。,
.操作：重新排序查询以包括相关的GROUPING_ID或GROUPING函数。,
.

aiaiDBA

13718043309

010-86462881

QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)

1 个回答

相似问题