[HIVE-23868] Windowing function spec: support 0 preceeding/following

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Query Planning
• Labels: pull-request-available
• Assignee: Jason Dere
• Reporter: Jason Dere
• Created: 16/Jul/20 23:14
• Updated: 27/Feb/24 22:23
• Resolved: 17/Jul/20 14:57

Description

HIVE-12574 removed support for 0 PRECEDING/FOLLOWING in window function specifications. We can restore support for this by converting 0 PRECEDING/FOLLOWING to CURRENT ROW in the query plan, which should be the same.

Issue Links

• is related to: HIVE-12574 windowing function returns incorrect result when the window size is larger than the partition size
• links to: GitHub Pull Request #1269
• links to: https://github.com/apache/hive/pull/1269