QSM-02176: MV with UNION ALL in a view is too complex

QSM-02176: MV with UNION ALL in a view is too complex
Cause: If a materialized view has a view whose definition involves a UNION ALL query, then the materialized view's defining query cannot have any clauses other than SELECT or FROM. Other clauses such as WHERE, HAVING, CONNECT BY, or GROUP BY are not allowed. Further more, the FROM clause should have only one item.
Action: Remove any clauses besides SELECT and FROM from the materialized view's defining query.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02176：视图中的UNION ALL的MV太复杂了,
.原因：如果物化视图具有定义涉及UNION ALL查询的视图，则物化视图的定义查询不能具有除SELECT或FROM之外的任何子句。其他条款如WHERE，HAVING，CONNECT BY或GROUP BY不允许。此外，FROM子句应该只有一个项目。,
.操作：从物化视图的定义查询中除去SELECT和FROM之外的所有子句。,
.

aiaiDBA

13718043309

010-86462881

QSM-02176: MV with UNION ALL in a view is too complex

1 个回答

相似问题