[
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}
As part of this JIRA task only the following syntax will be supported:
{noformat}
<lead or lag function> ::=
<lead or lag> ( <lead or lag extent> )
{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}
The following won't be supported until CALCITE-337 is resolved:
{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}
> As part of this JIRA task only the following syntax will be supported:
> {noformat}
> <lead or lag function> ::=
> <lead or lag> ( <lead or lag extent> )
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
