[
https://issues.apache.org/jira/browse/ASTERIXDB-2466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16671086#comment-16671086
]
ASF subversion and git services commented on ASTERIXDB-2466:
------------------------------------------------------------
Commit fdedf6263cca9bb87a2baf0eccb7864a26c8aaf9 in asterixdb's branch
refs/heads/master from [~dlychagin-cb]
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=fdedf62 ]
[ASTERIXDB-2466][FUN] Implement window functions
- user model changes: yes
- storage format changes: no
- interface changes: no
Details:
- Implement window functions with SQL syntax:
function() OVER ((PARTITION BY expr1, expr2, ...)? ORDER BY exprA, exprB, ...)
- Where supported functions are:
ROW_NUMBER(), RANK(), DENSE_RANK(), PERCENT_RANK(), NTILE()
Change-Id: Ia28af8773cb11049c38d440c51b9c3cd1ed2bab4
Reviewed-on: https://asterix-gerrit.ics.uci.edu/3002
Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Contrib: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <ali.al.solai...@gmail.com>
> Initial implementation of window functions
> ------------------------------------------
>
> Key: ASTERIXDB-2466
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2466
> Project: Apache AsterixDB
> Issue Type: Task
> Components: FUN - Functions
> Reporter: Dmitry Lychagin
> Assignee: Dmitry Lychagin
> Priority: Major
>
> Implement window functions using SQL syntax
> func() OVER ( (PARTITION BY expr1, expr2, .. exprN)? ORDER BY exprA, exprB,
> .... )
> Where supported functions are:
> ROW_NUMBER(), RANK(), DENSE_RANK(), PERCENT_RANK(), NTILE()
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
