[jira] [Commented] (HIVE-26370) Check stats are up-to-date when getting materialized view state

["Krisztian Kasa (Jira)" <ji...@apache.org>]

    [ 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)