You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently there is no coordination between skipping index and materialized view auto refresh. In the case of materialized view with filtering condition that can be accelerated by skipping index, the initial backlog processing should be fine. However, when MV refresh catches up, each micro batch of skipping index refresh on same source file list is not guaranteed to finish before MV. If hybrid scan is not enabled, skipping index may tell MV there is no file matched the filtering condition for current micro batch.
What solution would you like?
Add basic IT to make sure MV refresh can be accelerated by skipping index
Look into code to verify if the issue above may happen
Quick solution would be enabling hybrid scan mode in this case
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem?
Currently there is no coordination between skipping index and materialized view auto refresh. In the case of materialized view with filtering condition that can be accelerated by skipping index, the initial backlog processing should be fine. However, when MV refresh catches up, each micro batch of skipping index refresh on same source file list is not guaranteed to finish before MV. If hybrid scan is not enabled, skipping index may tell MV there is no file matched the filtering condition for current micro batch.
What solution would you like?
The text was updated successfully, but these errors were encountered: