QSM-02123: subquery and UNION mv's must be primary key mv's

QSM-02123: subquery and UNION mv's must be primary key mv's
Cause: The capability in question is not supported when the materialized view is not a primary key materialized view and uses subqueries or the union operator in this context.
Action: Re-create the materialized view as a primary key materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02123：子查询和UNION mv必须是主键mv,
.原因：当物化视图不是主键物化视图并且在此上下文中使用子查询或联合运算符时，不支持该问题的功能。,
.操作：将物化视图重新创建为主键实体化视图。,
.

aiaiDBA

13718043309

010-86462881

QSM-02123: subquery and UNION mv's must be primary key mv's

1 个回答

相似问题