Khurram Faraaz created DRILL-3596:
-------------------------------------

             Summary: Allow only (<expression>,default offset) in 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: Chris Westin


We need to disable the third input parameter in LEAD and LAG window functions. 
We should support this syntax.

LEAD(<expression>,1)
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)

Reply via email to