[
https://issues.apache.org/jira/browse/SPARK-14361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xin Wu updated SPARK-14361:
---------------------------
Description:
The current Spark SQL does not support the exclusion clause in Window function
framing, 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 this 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}
was:
The current Spark SQL does not support the `exclusion` clause, which is part of
ANSI
SQL2003’s `Window` syntax. For example, IBM Netezza fully supports it as shown
in the
[document web link]
(https://www.ibm.com/support/knowledgecenter/SSULQD_7.1.0/com.ibm.nz.dbu.doc/c_dbuser_wi
ndow_aggregation_family_syntax.html). This PR is to fill the gap.
> 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 exclusion clause in Window
> function framing, 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 this 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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
