[jira] [Created] (HIVE-25656) Get materialized view state based on number of affected rows by transactions

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

Krisztian Kasa created HIVE-25656:
-------------------------------------

             Summary: Get materialized view state based on number of affected rows by transactions
                 Key: HIVE-25656
                 URL: https://issues.apache.org/jira/browse/HIVE-25656
             Project: Hive
          Issue Type: Improvement
          Components: Materialized views, Transactions
            Reporter: Krisztian Kasa
            Assignee: Krisztian Kasa
             Fix For: 4.0.0


To enable the faster incremental rebuild of materialized views presence of update/delete operations on the source tables of the view since the last rebuild must be checked. Based on the outcome different plan is generated for scenarios in presence of update/delete and insert only operations.

Currently this is done by querying the COMPLETED_TXN_COMPONENTS table however the records from this table is cleaned when MV source tables are compacted. This reduces the chances of incremental MV rebuild.

The goal of this patch is to find an alternative way to store and retrieve this information.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)