[jira] [Updated] (HIVE-27353) Show saved snapshot of materialized view source tables

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-27353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ASF GitHub Bot updated HIVE-27353:
----------------------------------
    Labels: pull-request-available  (was: )

> Show saved snapshot of materialized view source tables
> ------------------------------------------------------
>
>                 Key: HIVE-27353
>                 URL: https://issues.apache.org/jira/browse/HIVE-27353
>             Project: Hive
>          Issue Type: Improvement
>          Components: Materialized views
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Minor
>              Labels: pull-request-available
>
> HIVE-25745 introduced a new section into
> {code:java}
> DESCRIBE FORMATTED <view name>;
> {code}
> output:
> {code:java}
> # Materialized View Source table information	 	 
> Table name          	I/U/D since last rebuild	 
> hive.default.src_txn	0/0/0               	 
> hive.default.src_txn_2	0/0/0               	 
> {code}
> Unfortunately transactional stats are not reliable because such stats are supposed to be saved along with basic stats.
> If something blocks saving the stats like
> {code:java}
> set hive.stats.autogather=false;
> {code}
> basic stats still can be refreshed using
> {code:java}
> analyze table <table> compute statistics;
> {code}
> but it won't collect and update transactional since the amount of rows affected by recent transactions are no longer available and can not be calculated.
>  
> The goal of this jira is to print the saved snapshot information of each source table instead:
> * writeId in case of native acid tables
> * snapshotId in case of iceberg tables
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)