QSM-02177: MV with UNION ALL in a view must match the view's SELECT list

QSM-02177: MV with UNION ALL in a view must match the view's SELECT list
Cause: If a materialized view has a view whose definition involves a UNION ALL query, then the materialized view's select list must match the underlying view's select list exactly. It must not have any expressions and must not have add/drop/reorder columns from the underlying view.
Action: Use select * when defining a materialized view with a UNION ALL in a view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02177：视图中的UNION ALL的MV必须与视图的SELECT列表匹配,
.原因：如果物化视图具有定义涉及UNION ALL查询的视图，则物化视图的选择列表必须与底层视图的选择列表完全匹配。它不能有任何表达式，并且不能从底层视图添加/删除/重新排序列。,
.操作：在视图中使用UNION ALL定义实例化视图时，请使用select *。,
.

aiaiDBA

13718043309

010-86462881

QSM-02177: MV with UNION ALL in a view must match the view's SELECT list

1 个回答

相似问题