[
https://issues.apache.org/jira/browse/HIVE-25805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-25805:
----------------------------------
Labels: pull-request-available (was: )
> Wrong result when rebuilding MV with count(col) incrementally
> -------------------------------------------------------------
>
> Key: HIVE-25805
> URL: https://issues.apache.org/jira/browse/HIVE-25805
> Project: Hive
> Issue Type: Bug
> Components: CBO, Materialized views
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> {code:java}
> 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;
> {code}
> returns
> {code:java}
> new 1 1
> {code}
> but, should be
> {code:java}
> new 0 1
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
