Details
-
Improvement
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
HIVE-25745 introduced a new section into
DESCRIBE FORMATTED <view name>;
output:
# 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
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
set hive.stats.autogather=false;
basic stats still can be refreshed using
analyze table <table> compute statistics;
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
Attachments
Issue Links
- fixes
-
HIVE-25745 Print transactional stats of materialized view source tables
- Resolved
- links to