[
https://issues.apache.org/jira/browse/KYLIN-4658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhong Yanghong updated KYLIN-4658:
----------------------------------
Description:
Test SQL:
{code}
select CNT, GMV, sum(GMV) over(partition by SLR_SEGMENT_CD) TOTAL_GMV,
SLR_SEGMENT_CD, LSTG_FORMAT_NAME
from
(select sum(PRICE) GMV, sum(ITEM_COUNT) CNT, SLR_SEGMENT_CD, LSTG_FORMAT_NAME
from TEST_KYLIN_FACT group by SLR_SEGMENT_CD, LSTG_FORMAT_NAME
UNION ALL
select sum(PRICE) GMV, sum(ITEM_COUNT) CNT, SLR_SEGMENT_CD, LSTG_FORMAT_NAME
from TEST_KYLIN_FACT group by SLR_SEGMENT_CD, LSTG_FORMAT_NAME)
order by TOTAL_GMV
{code}
Exception:
{code}
Index: 2, Size: 2 while executing SQL: "select * from (select CNT, GMV,
sum(GMV) over(partition by SLR_SEGMENT_CD) TOTAL_GMV, SLR_SEGMENT_CD,
LSTG_FORMAT_NAME from (select sum(PRICE) GMV, sum(ITEM_COUNT) CNT,
SLR_SEGMENT_CD, LSTG_FORMAT_NAME from TEST_KYLIN_FACT group by SLR_SEGMENT_CD,
LSTG_FORMAT_NAME UNION ALL select sum(PRICE) GMV, sum(ITEM_COUNT) CNT,
SLR_SEGMENT_CD, LSTG_FORMAT_NAME from TEST_KYLIN_FACT group by SLR_SEGMENT_CD,
LSTG_FORMAT_NAME) order by TOTAL_GMV) limit 50000"
{code}
> Windows function does not work for union all
> --------------------------------------------
>
> Key: KYLIN-4658
> URL: https://issues.apache.org/jira/browse/KYLIN-4658
> Project: Kylin
> Issue Type: Improvement
> Reporter: Zhong Yanghong
> Assignee: Zhong Yanghong
> Priority: Major
>
> Test SQL:
> {code}
> select CNT, GMV, sum(GMV) over(partition by SLR_SEGMENT_CD) TOTAL_GMV,
> SLR_SEGMENT_CD, LSTG_FORMAT_NAME
> from
> (select sum(PRICE) GMV, sum(ITEM_COUNT) CNT, SLR_SEGMENT_CD, LSTG_FORMAT_NAME
> from TEST_KYLIN_FACT group by SLR_SEGMENT_CD, LSTG_FORMAT_NAME
> UNION ALL
> select sum(PRICE) GMV, sum(ITEM_COUNT) CNT, SLR_SEGMENT_CD, LSTG_FORMAT_NAME
> from TEST_KYLIN_FACT group by SLR_SEGMENT_CD, LSTG_FORMAT_NAME)
> order by TOTAL_GMV
> {code}
>
> Exception:
> {code}
> Index: 2, Size: 2 while executing SQL: "select * from (select CNT, GMV,
> sum(GMV) over(partition by SLR_SEGMENT_CD) TOTAL_GMV, SLR_SEGMENT_CD,
> LSTG_FORMAT_NAME from (select sum(PRICE) GMV, sum(ITEM_COUNT) CNT,
> SLR_SEGMENT_CD, LSTG_FORMAT_NAME from TEST_KYLIN_FACT group by
> SLR_SEGMENT_CD, LSTG_FORMAT_NAME UNION ALL select sum(PRICE) GMV,
> sum(ITEM_COUNT) CNT, SLR_SEGMENT_CD, LSTG_FORMAT_NAME from TEST_KYLIN_FACT
> group by SLR_SEGMENT_CD, LSTG_FORMAT_NAME) order by TOTAL_GMV) limit 50000"
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
