QSM-02020: container column not in SELECT list with NOT NULL constraint

QSM-02020: container column not in SELECT list with NOT NULL constraint
Cause: The capability in question is not supported when the materialized view's container table has a column that does not correspond to an output expression in the select list, and that column has a NOT NULL constraint. This situation can result in problems during refresh since any new rows inserted into the materialized view will set that column to NULL.
Action: Disable or remove the NOT NULL constraint.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02020：容器列不在具有NOT NULL约束的SELECT列表中,
.原因：当物化视图的容器表具有与选择列表中的输出表达式不对应的列，并且该列具有NOT NULL约束时，不支持所讨论的功能。这种情况可能会在刷新期间导致问题，因为插入物化视图的任何新行都将该列设置为NULL。,
.操作：禁用或删除NOT NULL约束。,
.

aiaiDBA

13718043309

010-86462881

QSM-02020: container column not in SELECT list with NOT NULL constraint

1 个回答

相似问题