[jira] [Assigned] (HIVE-24992) Incremental rebuild of MV having aggregate in presence of delete operation

["Krisztian Kasa (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-24992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krisztian Kasa reassigned HIVE-24992:
-------------------------------------


> 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
>            Priority: Major
>
> 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)