QSM-02170: tables must be identical across the UNION operator

QSM-02170: tables must be identical across the UNION operator
Cause: You have specified a materialized view using the UNION operator and the tables on each side of the UNION operator do not match. Fast refresh is not supported in this context.
Action: Restructure the materialized view query such that the respective sides of the UNION operator have the same table.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02170：在UNION操作符之间的表必须相同,
.原因：您已使用UNION操作符指定了实例化视图，并且UNION运算符两边的表不匹配。在此上下文中不支持快速刷新。,
.操作：重构物化视图查询，使得UNION运算符的各个相应表具有相同的表。,
.

aiaiDBA

13718043309

010-86462881

QSM-02170: tables must be identical across the UNION operator

1 个回答

相似问题