You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Zhu, Lipeng (JIRA)" <ji...@apache.org> on 2019/07/09 03:19:00 UTC
[jira] [Updated] (SPARK-28310) ANSI SQL grammar support:
first_value/last_value(expression, [RESPECT NULLS | IGNORE NULLS])
[ https://issues.apache.org/jira/browse/SPARK-28310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhu, Lipeng updated SPARK-28310:
--------------------------------
Issue Type: Sub-task (was: Bug)
Parent: SPARK-27764
> ANSI SQL grammar support: first_value/last_value(expression, [RESPECT NULLS | IGNORE NULLS])
> --------------------------------------------------------------------------------------------
>
> Key: SPARK-28310
> URL: https://issues.apache.org/jira/browse/SPARK-28310
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Zhu, Lipeng
> Priority: Major
>
> According to the ANSI SQL 2011:
> {code:sql}
> <default expression> ::= <value expression>
> <null treatment> ::= RESPECT NULLS | IGNORE NULLS
> <first or last value function> ::=
> <first or last value> <left paren> <value expression> <right paren> [ <null treatment>
> ]
> <first or last value> ::=
> FIRST_VALUE | LAST_VALUE
> {code}
> Teradata - [https://docs.teradata.com/reader/756LNiPSFdY~4JcCCcR5Cw/SUwCpTupqmlBJvi2mipOaA]
> Oracle - [https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/FIRST_VALUE.html#GUID-D454EC3F-370C-4C64-9B11-33FCB10D95EC]
> Redshift – [https://docs.aws.amazon.com/redshift/latest/dg/r_WF_first_value.html]
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org