Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.0.0
-
None
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
Attachments
Attachments
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
-
- Resolved
-
- relates to
-
HIVE-23868 Windowing function spec: support 0 preceeding/following
-
- Closed
-
- links to