QSM-01099: non-tolerated reference to stale portion of mv for table string

QSM-01099: non-tolerated reference to stale portion of mv for table string
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-01099：不允许对表字符串 mv的陈旧部分引用,
.原因：物化视图部分陈旧。相对于其一个或多个细节表中的一个或多个分区，它是陈旧的。请求查询引用一个或多个此类详细分区。,
.操作：（1）更改请求的选择条件以将查询限制为仅实例化视图的新鲜部分，或（2）ALTER {SYSTEM | SESSION} QUERY_REWRITE_INTEGRITY = STALE_TOLERATED或（3）刷新实例化视图。,
.

aiaiDBA

13718043309

010-86462881

QSM-01099: non-tolerated reference to stale portion of mv for table string

1 个回答

相似问题