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

No comments:

Post a Comment