[
https://issues.apache.org/jira/browse/DRILL-3596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14710125#comment-14710125
]
ASF GitHub Bot commented on DRILL-3596:
---------------------------------------
GitHub user adeneche opened a pull request:
https://github.com/apache/drill/pull/128
DRILL-3596: Allow only (<expression>) or (<expression>, 1) for LEAD a…
…nd LAG window functions as input parameters
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/adeneche/incubator-drill DRILL-3596
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/128.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 #128
----
commit 87e411f38665c3c4cdf4313516862505a4cfdf0c
Author: adeneche <[email protected]>
Date: 2015-08-24T20:37:25Z
DRILL-3596: Allow only (<expression>) or (<expression>, 1) for LEAD and LAG
window functions as input parameters
----
> Allow only (<expression>) or (<expression>, 1) for LEAD and LAG window
> functions as input parameters
> ----------------------------------------------------------------------------------------------------
>
> Key: DRILL-3596
> URL: https://issues.apache.org/jira/browse/DRILL-3596
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 1.2.0
> Reporter: Khurram Faraaz
> Assignee: Deneche A. Hakim
> Labels: window_function
> Fix For: 1.2.0
>
>
> We need to disable the third input parameter in LEAD and LAG window
> functions. We should support this syntax.
> LEAD(<expression>) ,or LEAD(<expression>,1)
> LAG(<expression>), or LAG(<expression>,1)
> In both the functions above, the second parameter is the default offset
> value, use of any other value must he handled and reported to user as error.
> Use of a third input parameter to both the functions must be disallowed.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
