GitHub user adeneche opened a pull request:
https://github.com/apache/drill/pull/107
Drill 3536: Initial patch
Adding support for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTILE
This is not the final patch
- I still need to add proper documentation
- I added a new "aggregate" function named HoldLast, it's sole purpose is
to hold a value between batches (it's being used by first_value/last_value
window functions). I may have a solution that uses an internal batch (like I
did for LAG), this should improve the performance of first_value/last_value
functions and remove the need for HoldLast.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/adeneche/incubator-drill DRILL-3536
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/107.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 #107
----
commit b0cef7617250bc53d7acfc7c893e2c18b9d27374
Author: adeneche <[email protected]>
Date: 2015-07-23T23:38:44Z
restored GenerateTestData
commit aa015a567c6369fa1381b8af7242b1cce73bb635
Author: adeneche <[email protected]>
Date: 2015-08-02T16:53:13Z
DRILL-3553: add support for LEAD and LAG window functions
commit 1df614fbe95c2bb27df7a6a34a8921a06ebe2ba1
Author: adeneche <[email protected]>
Date: 2015-08-05T16:27:24Z
added unit tests for fixed bugs 3604, 3605 and 3606
commit 3556f8584b205a7222618c2288d13f4a2db0e064
Author: adeneche <[email protected]>
Date: 2015-08-05T17:47:44Z
refactoring how window function are being materialized
commit a02df37bf30e57fae59c38abc7f829860bc65403
Author: adeneche <[email protected]>
Date: 2015-08-06T17:09:53Z
DRILL-3536: Add support for FIRST_VALUE and LAST_VALUE window functions
commit 227c0608170556bc934c77aae6f82fbcb99e5ff0
Author: adeneche <[email protected]>
Date: 2015-08-10T16:46:38Z
DRILL-3608: add support for NTILE window function
----
---
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.
---
