[HIVE-11025] In windowing spec, when the datatype is decimal, it's comparing the value against NULL value incorrectly

• 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: 1.3.0
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 16/Jun/15 19:32
• Updated: 16/Feb/16 23:50
• Resolved: 22/Jun/15 18:25

Description

Given data and the following query,

deptno  empno  bonus    salary
30        7698         NULL    2850.0 
30        7900         NULL    950.0 
30        7844         0       1500.0 

select avg(salary) over (partition by deptno order by bonus range 200 preceding) from emp2;

It produces incorrect result for the row in which bonus=0
1900.0
1900.0
1766.6666666666667

Issue Links

• links to: code review