[ 
https://issues.apache.org/jira/browse/HIVE-27366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ASF GitHub Bot updated HIVE-27366:
----------------------------------
    Labels: pull-request-available  (was: )

> Incorrect incremental rebuild mode shown of materialized view with Iceberg 
> sources
> ----------------------------------------------------------------------------------
>
>                 Key: HIVE-27366
>                 URL: https://issues.apache.org/jira/browse/HIVE-27366
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Major
>              Labels: pull-request-available
>
> {code}
> CREATE TABLE shtb_test1(KEY INT, VALUE STRING) PARTITIONED BY(ds STRING)
> stored by iceberg stored as orc tblproperties ('format-version'='2');
> CREATE MATERIALIZED VIEW shtb_test1_view1 stored by iceberg stored as orc 
> tblproperties ('format-version'='1') AS
> SELECT * FROM shtb_test1 where KEY > 1000 and KEY < 2000;
> SHOW MATERIALIZED VIEWS;
> {code}
> {code}
> # MV Name             Rewriting Enabled       Mode                    
> Incremental rebuild 
> shtb_test1_view1      Yes                     Manual refresh          
> Available           
> {code}
> It should be 
> {code}
> # MV Name             Rewriting Enabled       Mode                    
> Incremental rebuild 
> shtb_test1_view1      Yes                     Manual refresh          
> Available in presence of insert operations only
> {code}
> because deleted rows can not be identified in case of Iceberg source tables.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to