[ https://issues.apache.org/jira/browse/HIVE-26370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17563594#comment-17563594 ]
Krisztian Kasa commented on HIVE-26370: --------------------------------------- Seems that relying on statistic only when querying MV status is not enough. I propose to switch back to check the state by querying the compaction queue and txn log. (HIVE-26375) [~shahbaz786] Could you please share your thoughts about any other solution? > Check stats are up-to-date when getting materialized view state > --------------------------------------------------------------- > > Key: HIVE-26370 > URL: https://issues.apache.org/jira/browse/HIVE-26370 > Project: Hive > Issue Type: Bug > Components: Materialized views, Statistics, Transactions > Reporter: Krisztian Kasa > Assignee: shahbaz > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 10m > Remaining Estimate: 0h > > Since HIVE-25656 materialized view state depends on the number of affected > rows of transactions made on the source tables. > If > {code} > hive.stats.autogather=false; > {code} > the number of affected rows of transactions are not collected and it can > cause invalid stats of source tables which leads to false indications about > MV status. -- This message was sent by Atlassian Jira (v8.20.10#820010)