Krisztian Kasa created HIVE-26375:
-------------------------------------
Summary: Invalid materialized view after rebuild if source table
was compacted
Key: HIVE-26375
URL: https://issues.apache.org/jira/browse/HIVE-26375
Project: Hive
Issue Type: Bug
Components: Materialized views, Transactions
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa
Fix For: 4.0.0
After HIVE-25656 MV state depends on the number of rows deleted/updated in the
source tables of the view. However if one of the source tables are major
compacted the delete delta files are no longer available and reproducing the
rows should be deleted from the MV is no longer possible.
{code}
create table t1(a int, b varchar(128), c float) stored as orc TBLPROPERTIES
('transactional'='true');
insert into t1(a,b, c) values (1, 'one', 1.1), (2, 'two', 2.2), (NULL, NULL,
NULL);
create materialized view mv1 stored as orc TBLPROPERTIES
('transactional'='true') as select a,b,c from t1 where a > 0 or a is null;
update t1 set b = 'Changed' where a = 1;
alter table t1 compact 'major';
alter materialized view t1 rebuild;
select * from mv1;
{code}
Select should result
{code}
"1\tChanged\t1.1",
"2\ttwo\t2.2",
"NULL\tNULL\tNULL"
{code}
but was
{code}
"1\tone\t1.1",
"2\ttwo\t2.2",
"NULL\tNULL\tNULL",
"1\tChanged\t1.1"
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
