[HIVE-10911] Add support for date datatype in the value based windowing function

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 2.0.0
• Component/s: PTF-Windowing
• Labels: TODOC2.0
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 03/Jun/15 21:07
• Updated: 16/Feb/16 23:52
• Resolved: 06/Jun/15 18:04

Description

Currently date datatype is not supported in value based windowing function.

For the following query with hiredate to be date type, an exception will be thrown.

select deptno, ename, hiredate, sal, sum(sal) over (partition by deptno order by hiredate range 90 preceding) from emp;

It's valuable to support such type with number of days as the value difference.

Issue Links

• links to: Code review