[
https://issues.apache.org/jira/browse/TAJO-774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14027296#comment-14027296
]
ASF GitHub Bot commented on TAJO-774:
-------------------------------------
Github user hyunsik commented on the pull request:
https://github.com/apache/tajo/pull/13#issuecomment-45691619
Thank you for the review.
I pushed the latest updated code for window function. The last revision
adds lots of verification codes and allows OVER clause to support aggregation
expressions. In other words, users can directly use aggregation functions
within OVER clause.
Example:
```
select l_orderkey, count(*) as cnt, row_number() over (order by count(*)
desc) row_num from lineitem group by l_orderkey order by l_orderkey
```
or
```
select l_orderkey, row_number() over (partition by l_orderkey order by
count(*) desc) row_num from lineitem group by l_orderkey;
```
I've added a number of unit tests for various cases which can be used in
OVER clause. I verified 'mvn clean install'.
Thanks!
> Implement logical plan part and physical executor for window function.
> ----------------------------------------------------------------------
>
> Key: TAJO-774
> URL: https://issues.apache.org/jira/browse/TAJO-774
> Project: Tajo
> Issue Type: Sub-task
> Components: planner/optimizer
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.9.0
>
>
> See the title. The main objective of this issue is to implement the logical
> planning part for window function support.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
