[jira] [Comment Edited] (SPARK-14361) Support EXCLUDE clause in Window function framing

["Xin Wu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-14361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15223702#comment-15223702 ] 

Xin Wu edited comment on SPARK-14361 at 4/4/16 6:06 AM:
--------------------------------------------------------

[~hvanhovell] Since you coded the whole window function.. I would like to have you take a look at the PR proposal.. I will submit a PR soon. 


was (Author: xwu0226):
[~smilegator][~dkbiswal]

> Support EXCLUDE clause in Window function framing
> -------------------------------------------------
>
>                 Key: SPARK-14361
>                 URL: https://issues.apache.org/jira/browse/SPARK-14361
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 2.0.0
>            Reporter: Xin Wu
>
> The current Spark SQL does not support the *exclude* clause in Window function framing clause, which is part of ANSI SQL2003's Window syntax. For example, IBM Netezza fully supports it as shown in the https://www.ibm.com/support/knowledgecenter/SSULQD_7.1.0/com.ibm.nz.dbu.doc/c_dbuser_window_aggregation_family_syntax.html).. We propose to implement it in the JIRA.
> The ANSI SQL2003's Window syntax:
> {code}
> FUNCTION_NAME(expr) OVER {window_name | (window_specification)}
> window_specification ::= [window_name] [partitioning] [ordering] [framing]
> partitioning ::= PARTITION BY value[, value...] [COLLATE collation_name]
> ordering ::= ORDER [SIBLINGS] BY rule[, rule...]
> rule ::= {value | position | alias} [ASC | DESC] [NULLS {FIRST | LAST}]
> framing ::= {ROWS | RANGE} {start | between} [exclusion]
> start ::= {UNBOUNDED PRECEDING | unsigned-integer PRECEDING | CURRENT ROW}
> between ::= BETWEEN bound AND bound
> bound ::= {start | UNBOUNDED FOLLOWING | unsigned-integer FOLLOWING}
> exclusion ::= {EXCLUDE CURRENT ROW | EXCLUDE GROUP | EXCLUDE TIES | EXCLUDE NO OTHERS}
> {code}



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org