[ https://issues.apache.org/jira/browse/HIVE-25546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa updated HIVE-25546: ---------------------------------- Summary: Enable incremental rebuild of Materialized views with insert only source tables (was: Enable incremental rebuild of Materialized view with insert only source tables) > Enable incremental rebuild of Materialized views 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 > Priority: Major > > {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)