jiaan.geng created SPARK-30727: ---------------------------------- Summary: ANSI SQL: LAST_VALUE function Key: SPARK-30727 URL: https://issues.apache.org/jira/browse/SPARK-30727 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 3.0.0 Reporter: jiaan.geng
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. -- 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