[HIVE-25805] Wrong result when rebuilding MV with count(col) incrementally

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO, Materialized views
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 14/Dec/21 10:29
• Updated: 17/Nov/22 08:48
• Resolved: 21/Dec/21 13:38

Description

create table t1(a char(15), b int) stored as orc TBLPROPERTIES ('transactional'='true');

insert into t1(a, b) values ('old', 1);

create materialized view mat1 stored as orc TBLPROPERTIES ('transactional'='true') as
select t1.a, count(t1.b), count(*) from t1 group by t1.a;

delete from t1 where b = 1;

insert into t1(a,b) values
('new', null);

alter materialized view mat1 rebuild;

select * from mat1;

returns

new            	1	1

but, should be

new            	0	1

Issue Links

• links to: GitHub Pull Request #2872