drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deneche A. Hakim (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-3553) add support for LEAD and LAG window functions
Date Fri, 24 Jul 2015 22:08:04 GMT

     [ 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>
<lead or lag function> ::=
  <lead or lag> ( <lead or lag extent>
  [ , <offset> [ , <default expression> ] ] )
  [ <null treatment> ]
<lead or lag> ::=
  LEAD | LAG
<lead or lag extent> ::=
  <value expression>
<offset> ::=
  <exact numeric literal>
<default expression> ::=
  <value expression>
<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>
> <lead or lag function> ::=
>   <lead or lag> ( <lead or lag extent>
>   [ , <offset> [ , <default expression> ] ] )
>   [ <null treatment> ]
> <lead or lag> ::=
>   LEAD | LAG
> <lead or lag extent> ::=
>   <value expression>
> <offset> ::=
>   <exact numeric literal>
> <default expression> ::=
>   <value expression>
> <null treatment> ::=
>   RESPECT NULLS | IGNORE NULLS
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message