QSM-02150: select lists must be identical across the UNION operator

QSM-02150: select lists must be identical across the UNION operator
Cause: You have specified a materialized view using the UNION operator and the respective queries on each side of the UNION operator do not have the same select list. The RELATED_NAME column shows the alias of the first different select list item. The RELATED_NUM column shows the offset from the SELECT keyword to the start of this select list item.
Action: Restructure the materialized view query such that the respective sides of the UNION operator have identical select lists.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02150：选择列表必须在UNION运算符中相同,
.原因：您已使用UNION运算符指定了实例化视图，并且UNION运算符两边的相应查询不具有相同的选择列表。"_NAME_NAME“列显示了第一个不同的选择列表项的别名。RELATED_NUM列显示从SELECT关键字到该选择列表项的开始的偏移量。,
.操作：重构物化视图查询，使得UNION运算符的各个相应方具有相同的选择列表。,
.

aiaiDBA

13718043309

010-86462881

QSM-02150: select lists must be identical across the UNION operator

1 个回答

相似问题