Is there a way to set a timeout or otherwise ignore async ma StarRocks #questions-and-troubleshooting

Is there a way to set a timeout or otherwise ignor...

Kyle Goodale

09/30/2025, 2:07 PM

Is there a way to set a timeout or otherwise ignore async materialized view that have a consistency of

CHECKED

? When MV's get wedged and are struggling to refresh all queries start to fail if they even reference the same table that the MV's are derived from. The trace logs show it hanging for 12.5s attempting to refresh the MV which is already in the process of refreshing just taking a long time. I know I can update all views to have a consistency of

LOOSE

but I'd prefer to be able to control this query side.

Kyle Goodale

09/30/2025, 3:17 PM

Another reason to control this query side is that I may want to have the option to have check consistency here for some queries and in cases where the refresh takes too long it would be faster to just go to the datalake directly instead of waiting for a refresh here until the query times out.

Kyle Goodale

09/30/2025, 3:18 PM

But also in this case the MV is not even able to serve this query. I am simply selecting from the same table and because one MV is wedged, all queries to that external table timeout when planning

Robert Raharjo

09/30/2025, 9:54 PM

You might want to alter the mv property

Copy code

mv_rewrite_staleness_second

This allows the query to skip the mv if the it has not been refreshed within the specified value.

Kyle Goodale

10/01/2025, 2:28 PM

ill give that a try, ty

Open in Slack

Previous Next