QSM-01299: query rewrite not possible because materialized view string is partially stale

QSM-01299: query rewrite not possible because materialized view string is partially stale
Cause: The materialized view is partially stale. It is stale with respect to one or more partitions in one or more of its detail tables. The request query references one or more such detail partitions.
Action: (1) Change the selection criteria of the request to restrict the query to only the fresh portion of the materialized view, or (2) ALTER {SYSTEM|SESSION} QUERY_REWRITE_INTEGRITY = STALE_TOLERATED or (3) refresh the materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01299：查询重写不可能，因为物化视图字符串部分陈旧,
.原因：物化视图部分陈旧。相对于其一个或多个细节表中的一个或多个分区，它是陈旧的。请求查询引用一个或多个此类详细分区。,
.操作：（1）更改请求的选择条件以将查询限制为仅实例化视图的新鲜部分，或（2）ALTER {SYSTEM | SESSION} QUERY_REWRITE_INTEGRITY = STALE_TOLERATED或（3）刷新实例化视图。,
.

aiaiDBA

13718043309

010-86462881

QSM-01299: query rewrite not possible because materialized view string is partially stale

1 个回答

相似问题