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 <[email protected]>
Date: 2016-06-14T23:07:32Z
QUICKSTEP-20: Added parser support for SQL window aggregation function
commit cf0412e8fa911623349d61665499ef2ffc43197d
Author: shixuan <[email protected]>
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 [email protected] or file a JIRA ticket
with INFRA.
---
