Aihua Xu created HIVE-12574:
-------------------------------
Summary: windowing function returns incorrect result when the
window size is larger than the partition size
Key: HIVE-12574
URL: https://issues.apache.org/jira/browse/HIVE-12574
Project: Hive
Issue Type: Sub-task
Components: PTF-Windowing
Affects Versions: 2.0.0
Reporter: Aihua Xu
Assignee: Aihua Xu
In PTF windowing, when the partition is small and the window size is larger
than the partition size, we are seeing incorrect result.
{noformat}
CREATE TABLE sdy1(
ord int,
type string);
{noformat]
The data is:
{noformat}
2 a
3 a
1 a
{noformat}
The result is as follows for the query {{select ord, collect_set(ord) over
(partition by type order by ord rows between 1 preceding and 7 following) }}
{noformat}
1 [1,2,3]
2 [1,2,3]
3 [1,2,3]
{noformat}
The expected result is:
1 [1,2,3]
2 [1,2,3]
3 [2,3]
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
