[HIVE-24519] Optimize MV: Materialized views should not rebuild when tables are not modified

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Materialized views
• Labels: pull-request-available
• Assignee: Krisztian Kasa
• Reporter: Rajesh Balamohan
• Created: 10/Dec/20 11:14
• Updated: 27/Feb/24 22:23
• Resolved: 07/Jan/21 04:00

Description

e.g

create materialized view c_c_address as 
select c_customer_sk from customer c, customer_address ca where c_current_addr_sk = ca.ca_address_id;

ALTER MATERIALIZED VIEW c_c_address REBUILD; <-- This shouldn't trigger rebuild, when source tables are not modified

 

Issue Links

• links to: GitHub Pull Request #1772