[HIVE-10555] Improve windowing spec of range based windowing to support additional range formats - ASF JIRA

XML

Word

Printable

JSON

Currently windowing function only supports the formats of x preceding and current, x preceding and y following, current and y following.

Windowing of x preceding and y preceding and x following and y following doesn't work properly.

The following functions should be supported.
First_value(), last_value(), sum(), avg() , count(), min(), max()

is duplicated by

HIVE-9412 Window clause ROW BETWEEN for PRECEDING does not work

requires

HIVE-10140 Window boundary is not compared correctly

1.	Refactoring Windowing for sum() to pass WindowFrameDef instead of two numbers (1 for number of preceding and 1 for number of following)	Closed	Aihua Xu
2.	Improve sum() function over windowing to support additional range formats	Resolved	Aihua Xu
3.	COUNT(*) over windowing 'x preceding and y preceding' doesn't work properly	Closed	Aihua Xu
4.	Support min()/max() functions over x preceding and y preceding windowing	Closed	Aihua Xu
5.	Support First_value()/last_value() over x preceding and y preceding windowing	Closed	Aihua Xu
6.	Add tests to cover avg() function for 'x preceding and y preceding' windowing spec.	Closed	Aihua Xu
7.	windowing function returns incorrect result when the window size is larger than the partition size	Closed	Aihua Xu
8.	Similar to HIVE-12574, collect_set and count() give incorrect result when partition size is smaller than window size	Resolved	Aihua Xu