[
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)
