[HIVE-18394] Materialized view: "Create Materialized View" should default to rewritable ones

• Type: Improvement
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 3.1.0, 4.0.0-alpha-1
• Component/s: Materialized views
• Labels: TODOC3.0
• Target Version/s: 3.1.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Gopal Vijayaraghavan
• Created: 08/Jan/18 21:07
• Updated: 27/Feb/24 22:23
• Resolved: 29/May/18 03:25

Description

This is a usability ticket, since it is possible to end up creating materialized views and realize that they need an additional flag to be picked up by the optimizer to do rewrites to.

create materialized view ca as select * from customer, customer_address where c_current_addr_sk = ca_address_sk;
set hive.materializedview.rewriting=true;
select count(1) from customer, customer_address where c_current_addr_sk = ca_address_sk; -- does not use materialized view

Needs another step

alter materialized view ca enable rewrite;

And then, it kicks in

select count(1) from customer, customer_address where c_current_addr_sk = ca_address_sk;
OK
12000000
Time taken: 0.494 seconds, Fetched: 1 row(s)