[HIVE-12574] windowing function returns incorrect result when the window size is larger than the partition size

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0
• Component/s: PTF-Windowing
• Target Version/s: 2.0.0
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 02/Dec/15 21:42
• Updated: 16/Jul/20 23:15
• Resolved: 08/Dec/15 01:34

Description

In PTF windowing, when the partition is small and the window size is larger than the partition size, we are seeing incorrect result. It happens for max, min, first_value, last_value and sum functions.

CREATE TABLE sdy1(
ord int,
type string);

The data is:

2 a
3 a
1 a 

The result is as follows for the query select ord, min(ord) over (partition by type order by ord rows between 1 preceding and 7 following)

1 1
2 1
3 1 

The expected result is:

1 1
2 1
3 2

Issue Links

• is duplicated by: HIVE-12575 Similar to HIVE-12574, collect_set and count() give incorrect result when partition size is smaller than window size
• relates to: HIVE-23868 Windowing function spec: support 0 preceeding/following
• links to: Code review