[ https://issues.apache.org/jira/browse/SPARK-30726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17029717#comment-17029717 ]
jiaan.geng commented on SPARK-30726: ------------------------------------ I'm working on > 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. -- 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