Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-27353

Show saved snapshot of materialized view source tables

    XMLWordPrintableJSON

Details

    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

          Activity

            People

              kkasa Krisztian Kasa
              kkasa Krisztian Kasa
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: