Details
-
New Feature
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
A window function performs a calculation across a set of table rows associated with some window frame. Window function is the key feature for analytic applications. We need to support window function.
Window function support involves various issues, new grammar rules, logical planning, distributed planning, and physical planning. This is an umbrella issue. I'll create various subtasks.
Attachments
1.
|
Add parser rule and algebraic expression for window function | Resolved | Hyunsik Choi | |
2.
|
Implement logical plan part and physical executor for window function. | Resolved | Hyunsik Choi | |
3.
|
Implement LAG and LEAD window functions | Resolved | Keuntae Park | |
4.
|
Add FIRST_VALUE and LAST_VALUE window functions | Resolved | Keuntae Park | |
5.
|
Add STDDEV_SAMP and STDDEV_POP window functions | Resolved | Keuntae Park | |
6.
|
Add NTH_VALUE window function | Patch Available | Seungun Choe | |
7.
|
Add VAR_SAMP and VAR_POP window functions | Resolved | Dongjoon Hyun | |
8.
|
Merge the current window_function branch to master | Resolved | Hyunsik Choi | |
9.
|
Repeated using of the same order by key in multiple window clauses should be supported | Resolved | Keuntae Park | |
10.
|
Window frame support | Open | Keuntae Park | |
11.
|
Implement ntile window function | Patch Available | Seungun Choe |