Change theme
Help
Press space for more information.
Show links for this issue (Shortcut: i, l)
Copy issue ID
Previous Issue (Shortcut: k)
Next Issue (Shortcut: j)
Sign in to use full features.
Vote: I am impacted
Notification menu
Refresh (Shortcut: Shift+r)
Go home (Shortcut: u)
Pending code changes (auto-populated)
View issue level access limits(Press Alt + Right arrow for more information)
Unintended behavior
View staffing
Description
We've identified a potential mismatch between the materialized view refresh job's partition limit and the materialized view base table's partition limit.
The materialized view's base table currently has a partition limit of 10,000[1]. However, a Materialized view refresh job can only modify 4,000 partitions[2]. This discrepancy can cause refresh failures when a materialized view is created over a table with more than 4,000 partitions.
[1]: See Number of partitions per partitioned table in
[2]: See Number of partitions modified by a single job in