[HIVE-10140] Window boundary is not compared correctly

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.13.0, 0.14.0, 1.0.0, 1.1.0, 1.2.0
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: PTF-Windowing
• Assignee: Aihua Xu Assign to me
• Reporter: Yi Zhang
• Created: 30/Mar/15 16:02
• Updated: 16/Feb/16 23:52
• Resolved: 05/May/15 17:04

Description

“ROWS between 10 preceding and 2 preceding” is not handled correctly.

Underlying error: Window range invalid, start boundary is greater than end boundary: window(start=range(10 PRECEDING), end=range(2 PRECEDING))

If I change it to “2 preceding and 10 preceding”, the syntax works but the results are 0 of course.

Reason for the function: during analysis, it is sometimes desired to design the window to filter the most recent events, in the case of the events' responses are not available yet. There is a workaround for this, but it is better/more proper to fix the bug.

Issue Links

• is required by: HIVE-10555 Improve windowing spec of range based windowing to support additional range formats