Krisztian Kasa created HIVE-28006:
-------------------------------------
Summary: Materialized view with aggregate function incorrectly
shows it allows incremental rebuild
Key: HIVE-28006
URL: https://issues.apache.org/jira/browse/HIVE-28006
Project: Hive
Issue Type: Bug
Components: Materialized views
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa
{code}
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
create table store_sales (
ss_sold_date_sk int,
ss_ext_sales_price int,
ss_customer_sk int
) stored as orc TBLPROPERTIES ('transactional'='true');
insert into store_sales (ss_sold_date_sk, ss_ext_sales_price, ss_customer_sk)
values (2, 2, 2);
create materialized view mat1 stored as orc tblproperties
('format-version'='2') as
select ss_customer_sk
,min(ss_ext_sales_price)
,count(*)
from store_sales
group by ss_customer_sk;
delete from store_sales where ss_sold_date_sk = 1;
show materialized views;
explain cbo
alter materialized view mat1 rebuild;
{code}
Incremental rebuild is available
{code}
# MV Name Rewriting Enabled Mode
Incremental rebuild
mat1 Yes Manual refresh
Available
{code}
vs full rebuild plan
{code}
CBO PLAN:
HiveAggregate(group=[{2}], agg#0=[min($1)], agg#1=[count()])
HiveTableScan(table=[[default, store_sales]], table:alias=[store_sales])
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
