ERROR | 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 |