[
https://issues.apache.org/jira/browse/HIVE-11646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14721162#comment-14721162
]
Pengcheng Xiong commented on HIVE-11646:
----------------------------------------
[~jcamachorodriguez], thanks for your comments. The reality is that, it is
overwriting the previous window specs. For example {code}select p_mfgr,
p_retailprice, p_size,
round(sum(p_retailprice) over w1 , 2) = round(sum(lag(p_retailprice,1,0.0))
over w1 + last_value(p_retailprice) over w1 , 2),
max(p_retailprice) over w1 - min(p_retailprice) over w1 =
last_value(p_retailprice) over w1 - first_value(p_retailprice) over w1
from part
window w1 as (distribute by p_mfgr sort by p_retailprice){code}. And, that is
why I {code}getWindowColumnAlias() {code}. I will add this test case later.
> CBO: Calcite Operator To Hive Operator (Calcite Return Path): fix multiple
> window spec for PTF operator
> -------------------------------------------------------------------------------------------------------
>
> Key: HIVE-11646
> URL: https://issues.apache.org/jira/browse/HIVE-11646
> Project: Hive
> Issue Type: Sub-task
> Components: CBO
> Reporter: Pengcheng Xiong
> Assignee: Pengcheng Xiong
> Attachments: HIVE-11646.01.patch
>
>
> Current return path only supports a single windowing spec. All the following
> window spec will overwrite the first one.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
