[
https://issues.apache.org/jira/browse/HIVE-10555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aihua Xu updated HIVE-10555:
----------------------------
Description:
Currently windowing function only supports the formats of {{x preceding and
current}}, {{x preceding and y following}}, {{current and y following}}.
Windowing of {{x preceding and y preceding}} and {{x following and y following}
doesn't work properly.
was:
The following windowing function always returns 0 for count(*).
{noformat}
Table t1
key value
1 3
1 3
1 2
select key, count(*) over (partition by key order by value rows between 1
preceding and 2 preceding) from t1;
{noformat}
Seems windowing functions have some issues when dealing with preceding window.
> Windowing function to support additional ranges
> -----------------------------------------------
>
> Key: HIVE-10555
> URL: https://issues.apache.org/jira/browse/HIVE-10555
> Project: Hive
> Issue Type: Improvement
> Components: PTF-Windowing
> Affects Versions: 1.3.0
> Reporter: Aihua Xu
> Assignee: Aihua Xu
>
> Currently windowing function only supports the formats of {{x preceding and
> current}}, {{x preceding and y following}}, {{current and y following}}.
> Windowing of {{x preceding and y preceding}} and {{x following and y
> following} doesn't work properly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
