QSM-01295: no suitable grouping_id found in materialized view with grouping sets

QSM-01295: no suitable grouping_id found in materialized view with grouping sets
Cause: If materialized view contains grouping sets, then it also must contain the grouping_id() function. This function must contain all columns in the MV GROUP BY.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01295：在具有分组集的物化视图中找不到合适的grouping_id,
.原因：如果物化视图包含分组集，则它也必须包含grouping_id（）函数。此函数必须包含MV GROUP BY中的所有列。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

QSM-01295: no suitable grouping_id found in materialized view with grouping sets

1 个回答

相似问题