drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deneche A. Hakim (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-3553) add support for LEAD and LAG window functions
Date Tue, 18 Aug 2015 17:19:45 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Deneche A. Hakim resolved DRILL-3553.
-------------------------------------
    Resolution: Fixed

Fixed in b55e2328d929df5d361c038f63fdeffadb0e544c

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

Mime
View raw message