[
https://issues.apache.org/jira/browse/PHOENIX-7397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877745#comment-17877745
]
chenglei commented on PHOENIX-7397:
-----------------------------------
A common use case of union all is to union multiple homogeneous tables and then
further aggregate or sort , just as following sql statements：
{code:java}
select A, B,C, sum(...),sum(....)
from (
select a1 A, b1 B,c1 C, ....
from T1
union all
select a2,b2,c2,.....
from T2
union all
select a3,b3,c3, ....)
group by A,B,C
having....
{code}
{code:java}
select A, B,C, sum(...),sum(....)
from (
select a1 A, b1 B,c1 C, ....
from T1
union all
select a2,b2,c2,.....
from T2
union all
select a3,b3,c3, ....)
group by A,B,C
having....
{code}
> Optimize ClientAggregatePlan/ClientScanPlan when inner query plan is UnionPlan
> ------------------------------------------------------------------------------
>
> Key: PHOENIX-7397
> URL: https://issues.apache.org/jira/browse/PHOENIX-7397
> Project: Phoenix
> Issue Type: Improvement
> Components: core
> Affects Versions: 5.2.0, 5.1.3
> Reporter: chenglei
> Priority: Major
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
