QSM-01298: materialized view string clause more restrictive than query string clause

QSM-01298: materialized view string clause more restrictive than query string clause
Cause: The materialized view contains a selection condition in the WHERE or HAVING 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-01298：物化视图字符串子句比查询字符串子句更具限制性,
.原因：物化视图在WHERE或HAVING子句中包含比请求查询中的相应选择条件更严格的选择条件。,
.操作：将请求查询中的选择条件更改为至少与物化视图中的选择条件一样限制，或者使用较少限制的选择条件删除并重新创建物化视图。,
.

aiaiDBA

13718043309

010-86462881

QSM-01298: materialized view string clause more restrictive than query string clause

1 个回答

相似问题