QSM-02174: the materialized view does not have a UNION ALL marker column

QSM-02174: the materialized view does not have a UNION ALL marker column
Cause: For a materialized view with UNION ALL to be fast refreshable, it must have a UNION ALL marker column. This is a constant column, at the same ordinal position in each query block and must have distinct values in each query block.
Action: Add a UNION ALL marker column to each query block in the UNION ALL query defining the materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02174：物化视图没有UNION ALL标记列,
.原因：对于具有UNION ALL的实例化视图，可以快速刷新，它必须具有UNION ALL标记列。这是一个常量列，在每个查询块中位于相同的顺序位置，并且在每个查询块中必须具有不同的值。,
.操作：将UNION ALL标记列添加到定义实例化视图的UNION ALL查询中的每个查询块中。,
.

aiaiDBA

13718043309

010-86462881

QSM-02174: the materialized view does not have a UNION ALL marker column

1 个回答

相似问题