Krisztian Kasa created HIVE-24992:
-------------------------------------
Summary: Incremental rebuild of MV having aggregate in presence of
delete operation
Key: HIVE-24992
URL: https://issues.apache.org/jira/browse/HIVE-24992
Project: Hive
Issue Type: Improvement
Components: Materialized views
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa
Extension of HIVE-24854: handle cases when the Materialized view definition has
aggregation like
{code}
CREATE MATERIALIZED VIEW cmv_mat_view_n5 DISABLE REWRITE TBLPROPERTIES
('transactional'='true') AS
SELECT cmv_basetable_n5.a, cmv_basetable_2_n2.c, sum(cmv_basetable_2_n2.d)
FROM cmv_basetable_n5 JOIN cmv_basetable_2_n2 ON (cmv_basetable_n5.a =
cmv_basetable_2_n2.a)
WHERE cmv_basetable_2_n2.c > 10.0
GROUP BY cmv_basetable_n5.a, cmv_basetable_2_n2.c;
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
