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

["Krisztian Kasa (Jira)" <ji...@apache.org>]

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

Krisztian Kasa updated HIVE-25805:
----------------------------------
    Summary: Wrong result when rebuilding MV with count(col) incrementally  (was: Wrong result when rebuilding MV with count(col) incremental)

> 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
>
> {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)