[jira] [Created] (HIVE-20996) MV rewriting not triggering

[Vineet Garg (JIRA)]

Vineet Garg created HIVE-20996:
----------------------------------

             Summary: MV rewriting not triggering
                 Key: HIVE-20996
                 URL: https://issues.apache.org/jira/browse/HIVE-20996
             Project: Hive
          Issue Type: Improvement
            Reporter: Vineet Garg


{code:sql}
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.strict.checks.cartesian.product=false;
set hive.stats.fetch.column.stats=true;
set hive.materializedview.rewriting=true;

create table emps_n3 (
  empid int,
  deptno int,
  name varchar(256),
  salary float,
  commission int)
stored as orc TBLPROPERTIES ('transactional'='true');

insert into emps_n3 values (100, 10, 'Bill', 10000, 1000), (200, 20, 'Eric', 
8000, 500),
  (150, 10, 'Sebastian', 7000, null), (110, 10, 'Theodore', 10000, 250), (120, 
10, 'Bill', 10000, 250);

analyze table emps_n3 compute statistics for columns;

alter table emps_n3 add constraint pk1 primary key (empid) disable novalidate 
rely;

create materialized view mv1_n2 as
select empid, deptno from emps_n3 group by empid, deptno;


explain
select empid, deptno from emps_n3 group by empid, deptno;
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)