Rajesh Balamohan created HIVE-24519:
---------------------------------------

             Summary: Optimize MV: Materialized views should not rebuild when 
tables are not modified
                 Key: HIVE-24519
                 URL: https://issues.apache.org/jira/browse/HIVE-24519
             Project: Hive
          Issue Type: Improvement
          Components: Materialized views
            Reporter: Rajesh Balamohan


e.g
{noformat}
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

 {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to