You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gitbox@hive.apache.org by GitBox <gi...@apache.org> on 2021/07/22 14:07:35 UTC
[GitHub] [hive] kasakrisz opened a new pull request #2518: HIVE-25369: Handle Sum0 when rebuilding materialized view incrementally
kasakrisz opened a new pull request #2518:
URL: https://github.com/apache/hive/pull/2518
### What changes were proposed in this pull request?
Insert overwrite MV rebuild plans root operator is an Aggregate operator which contains `sum0` function if the MV definition has `count` aggregate function call. The incremental rebuild plan is going to be a Project which contains `case` expressions for each aggregate function call in the original plan. Add `sum0` function to the list of functions which can be transformed to `case` expression.
### Why are the changes needed?
Enable MVs containing count aggregate functions.
### Does this PR introduce _any_ user-facing change?
No.
### How was this patch tested?
Run existing MV rebuild tests and added a new one targeting MV with count.
```
mvn test -Dtest.output.overwrite -DskipSparkTests -Dtest=TestMiniLlapLocalCliDriver -Dqfile=materialized_view_create_rewrite.q,materialized_view_create_rewrite_2.q,materialized_view_create_rewrite_3.q,materialized_view_create_rewrite_4.q,materialized_view_create_rewrite_6.q,materialized_view_create_rewrite_7.q,materialized_view_create_rewrite_7.q,materialized_view_partitioned_create_rewrite_agg.q,materialized_view_partitioned_create_rewrite_agg_2.q -pl itests/qtest -Pitests
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] kasakrisz merged pull request #2518: HIVE-25369: Handle Sum0 when rebuilding materialized view incrementally
Posted by GitBox <gi...@apache.org>.
kasakrisz merged pull request #2518:
URL: https://github.com/apache/hive/pull/2518
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org