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 02:20:00 UTC
[jira] [Created] (SPARK-28310) ANSI SQL grammar support:
first_value/last_value(expression, [RESPECT NULLS | IGNORE NULLS])
Zhu, Lipeng created SPARK-28310:
-----------------------------------
Summary: 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: Bug
Components: SQL
Affects Versions: 3.0.0
Reporter: Zhu, Lipeng
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