quickstep-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shixuan-fan <...@git.apache.org>
Subject [GitHub] incubator-quickstep pull request #35: Added Parser support for SQL Window Ag...
Date Wed, 15 Jun 2016 20:05:11 GMT
GitHub user shixuan-fan opened a pull request:

    https://github.com/apache/incubator-quickstep/pull/35

    Added Parser support for SQL Window Aggregation Function

    Added parser support for SQL Window Aggregation Function.
    
    The parser will now understand the window aggregation function, the grammar will be like
    
    SELECT avg(attr1) OVER 
    (partition by attr2,
     order by attr3 desc nulls last,
     rows between 3 preceding and 3 following)
    FROM table1
    
    Also, we could give the window a name to make it look much cleaner:
    
    SELECT avg(attr1) OVER w1, sum(attr2) OVER w2 FROM table1
    WINDOW w1 AS ( ... window ... definition ... )
    WINDOW w2 AS ( ... window ... definition ... )
    
    Currently, when the resolver see a function with a window aggregation function, it will
report error saying that it is currently not supported.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/apache/incubator-quickstep SQL-window-aggregation

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-quickstep/pull/35.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #35
    
----
commit 3bcdd91e7edbd01d5a431c2baa3c6c336c83f63b
Author: shixuan <shixuan.fan@wisc.edu>
Date:   2016-06-14T23:07:32Z

    QUICKSTEP-20: Added parser support for SQL window aggregation function

commit cf0412e8fa911623349d61665499ef2ffc43197d
Author: shixuan <shixuan.fan@wisc.edu>
Date:   2016-06-15T18:01:09Z

    QUICKSTEP-20: added parser support for window aggregation functions

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message