Krisztian Kasa created HIVE-27366:
-------------------------------------
Summary: 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
{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)
