maropu commented on a change in pull request #29056:
URL: https://github.com/apache/spark/pull/29056#discussion_r457887886
##########
File path: docs/sql-ref-syntax-qry-select-groupby.md
##########
@@ -81,6 +81,9 @@ aggregate_name ( [ DISTINCT ] expression [ , ... ] ) [ FILTER
( WHERE boolean_ex
* **aggregate_name**
Specifies an aggregate function name (MIN, MAX, COUNT, SUM, AVG, etc.).
+ Note that `FIRST` and `LAST` have an optional `IGNORE NULLS` clause; when
the option specified,
+ it will returns the first or last value that is not null (or null if all
values are null).
+ **Syntax:** `[ FIRST | LAST ] ( [ distinct ] expression [ IGNORE NULLS ] )
[ FILTER ( WHERE boolean_expression ) ]`
Review comment:
We still need ` **Syntax:** [ FIRST | LAST ] ( [ distinct ] expression [
IGNORE NULLS ] ) [ FILTER ( WHERE boolean_expression ) ]`? It looks verbose to
me though.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
