Krisztian Kasa created HIVE-28050: ------------------------------------- Summary: Disable Incremental non aggregated materialized view rebuild in presence of delete operations Key: HIVE-28050 URL: https://issues.apache.org/jira/browse/HIVE-28050 Project: Hive Issue Type: Bug Components: Materialized views Reporter: Krisztian Kasa Assignee: Krisztian Kasa Fix For: 4.1.0
To support incremental rebuild of materialized views which definition does not have aggregate in presence of delete operations in any of its source tables the records of the source tables need to be uniquely identified and joined with the records present in the view. One possibility is to project ROW_IDs of each source table in the view definition but the writeId component is changing at delete. Another way is to project columns of primary keys or unique keys but these constraints are not enforced in Hive. -- This message was sent by Atlassian Jira (v8.20.10#820010)