QSM-01106: materialized view, string, is stale with respect to some partition(s) in the base table(s)

QSM-01106: materialized view, string, is stale with respect to some partition(s) in the base table(s)
Cause: Query is requesting some data from the MV that are stale with respect to some partitions in the base tables due to some updates.
Action: refresh the stale partitions and rerun the query

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01106：物化视图，字符串，相对于基表中的某些分区是陈旧的,
.原因：由于某些更新，查询正在请求相对于基表中的某些分区而过时的MV中的一些数据。,
.操作：刷新过期的分区并重新运行查询,
.

aiaiDBA

13718043309

010-86462881

QSM-01106: materialized view, string, is stale with respect to some partition(s) in the base table(s)

1 个回答

相似问题