QSM-01112: WHERE clause of mv, string, is more restrictive than query

QSM-01112: WHERE clause of mv, string, is more restrictive than query
Cause: The materialized view contains a selection condition in the WHERE clause that is more restrictive than the corresponding selection condition in the request query.
Action: Change the selection criteria in the request query to be at least as restrictive as the selection criteria in the materialized view, or drop and recreate the materialized view using less restrictive selection criteria.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01112：mv，string的 WHERE子句比查询更加限制,
.原因：物化视图在WHERE子句中包含比请求查询中相应选择条件更严格的选择条件。,
.操作：将请求查询中的选择条件更改为至少与物化视图中的选择条件一样限制，或者使用较少限制的选择条件删除并重新创建物化视图。,
.

aiaiDBA

13718043309

010-86462881

QSM-01112: WHERE clause of mv, string, is more restrictive than query

1 个回答

相似问题