Steve Carlin created HIVE-22260: ----------------------------------- Summary: Materialized view rewriting does not support `UNION` operator, exact match can work under view Key: HIVE-22260 URL: https://issues.apache.org/jira/browse/HIVE-22260 Project: Hive Issue Type: Sub-task Components: CBO Affects Versions: 3.1.2 Reporter: Steve Carlin Attachments: complex0.sql
In this case, a view can be created that hides some nastier syntax like a "union". A materialized view can contain the view with a simple query. So if the end query just uses the view, it should rewrite to the materialized view. A script is attached. An example of this: create view logical_complex0 as with t as (select c1 as a, c2 as b from tab1 where c2 in (select f from logical_simple where g > 0) union select tab3.c1 as c, tab4.c2 as d from tab3, tab4 where tab3.c2 = tab4.c2) select a, b from t; -- query separator create materialized view aview_complex0 stored as orc as select a as x, b as y, count(*) from logical_complex0 group by 1, 2; -- This message was sent by Atlassian Jira (v8.3.4#803005)