[ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Deneche A. Hakim updated DRILL-3553: ------------------------------------ Description: >From SQL standard here is the general format of LEAD and LAG: {noformat} <window function> ::= <lead or lag function> OVER <window name or specification> {noformat} {noformat} <lead or lag function> ::= <lead or lag> ( <lead or lag extent> [ , <offset> [ , <default expression> ] ] ) [ <null treatment> ] {noformat} {noformat} <lead or lag> ::= LEAD | LAG {noformat} {noformat} <lead or lag extent> ::= <value expression> {noformat} {noformat} <offset> ::= <exact numeric literal> {noformat} {noformat} <default expression> ::= <value expression> {noformat} The following won't be supported until CALCITE-337 is resolved: {noformat} <null treatment> ::= RESPECT NULLS | IGNORE NULLS {noformat} was: >From SQL standard here is the general format of LEAD and LAG: {noformat} <window function> ::= <lead or lag function> OVER <window name or specification> {noformat} {noformat} <lead or lag function> ::= <lead or lag> ( <lead or lag extent> [ , <offset> [ , <default expression> ] ] ) [ <null treatment> ] {noformat} {noformat} <lead or lag> ::= LEAD | LAG {noformat} {noformat} <lead or lag extent> ::= <value expression> {noformat} {noformat} <offset> ::= <exact numeric literal> {noformat} {noformat} <default expression> ::= <value expression> {noformat} {noformat} <null treatment> ::= RESPECT NULLS | IGNORE NULLS {noformat} > add support for LEAD and LAG window functions > --------------------------------------------- > > Key: DRILL-3553 > URL: https://issues.apache.org/jira/browse/DRILL-3553 > Project: Apache Drill > Issue Type: Sub-task > Components: Execution - Relational Operators > Reporter: Deneche A. Hakim > Assignee: Deneche A. Hakim > Labels: window_function > Fix For: 1.2.0 > > > From SQL standard here is the general format of LEAD and LAG: > {noformat} > <window function> ::= > <lead or lag function> OVER <window name or specification> > {noformat} > {noformat} > <lead or lag function> ::= > <lead or lag> ( <lead or lag extent> > [ , <offset> [ , <default expression> ] ] ) > [ <null treatment> ] > {noformat} > {noformat} > <lead or lag> ::= > LEAD | LAG > {noformat} > {noformat} > <lead or lag extent> ::= > <value expression> > {noformat} > {noformat} > <offset> ::= > <exact numeric literal> > {noformat} > {noformat} > <default expression> ::= > <value expression> > {noformat} > The following won't be supported until CALCITE-337 is resolved: > {noformat} > <null treatment> ::= > RESPECT NULLS | IGNORE NULLS > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)