Krisztian Kasa created HIVE-25546: ------------------------------------- Summary: Enable incremental rebuild of Materialized view with insert only source tables Key: HIVE-25546 URL: https://issues.apache.org/jira/browse/HIVE-25546 Project: Hive Issue Type: Improvement Components: CBO, Materialized views Reporter: Krisztian Kasa Assignee: Krisztian Kasa
{code} create table t1(a int, b int, c int) stored as parquet TBLPROPERTIES ('transactional'='true', 'transactional_properties'='insert_only'); create materialized view mat1 stored as orc TBLPROPERTIES ('transactional'='true') as select a, b, c from t1 where a > 10; {code} Currently materialized view *mat1* can not be rebuilt incrementally because it has an insert only source table (t1). Such tables does not have ROW_ID.write_id which is required to identify newly inserted records since the last rebuild. HIVE-25406 adds the ability to query write_id. -- This message was sent by Atlassian Jira (v8.3.4#803005)