QSM-01296: query rewrite not possible because materialized view contains duplicate grouping sets

QSM-01296: query rewrite not possible because materialized view contains duplicate grouping sets
Cause: Materialized view with grouping sets contains duplicates and no rewrite is supported for it. For example, GROUP BY GROUPING SET ((a), (a)) is not supported for rewrite.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01296：查询重写不可能，因为物化视图包含重复的分组集,
.原因：具有分组集的物化视图包含重复项，并且不支持重写。例如，GROUP BY GROUPING SET（（a），（a））不支持重写。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

QSM-01296: query rewrite not possible because materialized view contains duplicate grouping sets

1 个回答

相似问题