You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2019/01/03 21:04:00 UTC
[jira] [Commented] (ASTERIXDB-2488) Aggregate window functions
[ https://issues.apache.org/jira/browse/ASTERIXDB-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16733518#comment-16733518 ]
ASF subversion and git services commented on ASTERIXDB-2488:
------------------------------------------------------------
Commit f2c18aa9646238ab2487ce3a964edfe3e61dd6e1 in asterixdb's branch refs/heads/master from Dmitry Lychagin
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=f2c18aa ]
[ASTERIXDB-2488][COMP] Support aggregate window functions
- user model changes: yes
- storage format changes: no
- interface changes: no
Details:
- Implement aggregate window functions:
agg_func() OVER (frame_var AS)? (PARTITION BY ... ORDER BY ... frame_spec)
- Where agg_func is a SQL/SQL++ aggregate function
- Fix percent_rank() to always return 0 for the first tuple
- Fix ntile() to handle NULL argument
- Log query after each rewrite rule in SqlppQueryRewriter
- Implement toString() for ADayTimeDuration, fix it for AYearMonthDuration
- Add seek() method to RunFileReader
Change-Id: If0f71118a04c2dbd3462070673d52e67f076b7e1
Reviewed-on: https://asterix-gerrit.ics.uci.edu/3049
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Contrib: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
> Aggregate window functions
> --------------------------
>
> Key: ASTERIXDB-2488
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2488
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: COMP - Compiler
> Reporter: Dmitry Lychagin
> Assignee: Dmitry Lychagin
> Priority: Major
>
> # Add support for aggregates as window functions ( agg() over (....) ) where 'agg' is a SQL/SQL++ aggregate function
> # Implement window frame specification
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)