[jira] [Created] (HIVE-19114) MV rewriting not being triggered for last query in materialized_view_rewrite_4.q

[Jesus Camacho Rodriguez (JIRA)]

Jesus Camacho Rodriguez created HIVE-19114:
----------------------------------------------

             Summary: MV rewriting not being triggered for last query in 
materialized_view_rewrite_4.q
                 Key: HIVE-19114
                 URL: https://issues.apache.org/jira/browse/HIVE-19114
             Project: Hive
          Issue Type: Bug
          Components: Materialized views
    Affects Versions: 3.0.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


{code:sql}
create materialized view mv1 enable rewrite as
select dependents.empid, emps.deptno, count(distinct salary) as s
from emps
join dependents on (emps.empid = dependents.empid)
group by dependents.empid, emps.deptno;

select emps.deptno, count(distinct salary) as s
from emps
join dependents on (emps.empid = dependents.empid)
group by dependents.empid, emps.deptno;
{code}



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