[
https://issues.apache.org/jira/browse/FLINK-18441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wangpeibin updated FLINK-18441:
-------------------------------
Description:
The optimization of Local-Global Aggregation is invalid when the last_value
aggregation function exists, such as
{code:java}
select k, sum(v) as v, last_value(v) as last_v
from a
group by k
{code}
right now the ExecutionPlan is:
!image-2020-06-28-16-12-39-156.png!
but with the optimization of Local-Global Aggregation enabled, the
ExecutionPlan is supported to be：
!image-2020-06-28-16-15-38-173.png!
was:
The optimization of Local-Global Aggregation is invalid when the last_value
aggregation function exists, such as
{code:java}
select k1,k2,sum(v) as v, last_value(v) as last_v
from a
group by k1,k2
{code}
right now the ExecutionPlan is:
!image-2020-06-28-16-12-39-156.png!
but with the optimization of Local-Global Aggregation enabled, the
ExecutionPlan is supported to be：
!image-2020-06-28-16-15-38-173.png!
> support Local-Global Aggregation with LastValue Funciton
> ---------------------------------------------------------
>
> Key: FLINK-18441
> URL: https://issues.apache.org/jira/browse/FLINK-18441
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Reporter: wangpeibin
> Priority: Major
> Attachments: image-2020-06-28-16-12-39-156.png,
> image-2020-06-28-16-15-38-173.png
>
>
> The optimization of Local-Global Aggregation is invalid when the last_value
> aggregation function exists, such as
> {code:java}
> select k, sum(v) as v, last_value(v) as last_v
> from a
> group by k
> {code}
> right now the ExecutionPlan is:
> !image-2020-06-28-16-12-39-156.png!
> but with the optimization of Local-Global Aggregation enabled, the
> ExecutionPlan is supported to be：
> !image-2020-06-28-16-15-38-173.png!
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
