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

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: Materialized views
• Target Version/s: 3.0.0
• Assignee: Unassigned
• Reporter: Jesús Camacho Rodríguez
• Created: 05/Apr/18 02:28
• Updated: 27/Feb/24 22:24

Description

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;

Issue Links

• is caused by: HIVE-18839 Implement incremental rebuild for materialized views (only insert operations in source tables)