[ https://issues.apache.org/jira/browse/SPARK-30726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jiaan.geng updated SPARK-30726: ------------------------------- Description: I have checked PostgreSQL, Vertica, Oracle, Redshift, Presto, Teradata, FIRST_VALUE|LAST_VALUE is always used as a window function, not as an aggregate function. The FIRST_VALUE function currently provided can be used as both an aggregation function and a window function. Maybe we need to re-implement it. Reference discussion in https://github.com/apache/spark/pull/25082 was: I have checked PostgreSQL, Vertica, Oracle, Redshift, Presto, Teradata, FIRST_VALUE|LAST_VALUE is always used as a window function, not as an aggregate function. The FIRST_VALUE function currently provided can be used as both an aggregation function and a window function. Maybe we need to re-implement it. > ANSI SQL: FIRST_VALUE function > ------------------------------ > > Key: SPARK-30726 > URL: https://issues.apache.org/jira/browse/SPARK-30726 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: jiaan.geng > Priority: Major > > I have checked PostgreSQL, Vertica, Oracle, Redshift, Presto, Teradata, > FIRST_VALUE|LAST_VALUE is always used as a window function, not as an > aggregate function. > The FIRST_VALUE function currently provided can be used as both an > aggregation function and a window function. > Maybe we need to re-implement it. > Reference discussion in https://github.com/apache/spark/pull/25082 -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org