[ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14641182#comment-14641182 ]
Deneche A. Hakim commented on DRILL-3553: ----------------------------------------- Calcite only supports {{RESPECT NULLS}} by default (but not when explicitly stated in a query) for now. Until CALCITE-337 is fixed we won't be able to support {{IGNORE NULLS}} > 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} > {noformat} > <null treatment> ::= > RESPECT NULLS | IGNORE NULLS > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)