GuoPhilipse commented on a change in pull request #29056:
URL: https://github.com/apache/spark/pull/29056#discussion_r457913593



##########
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:
       now have have aggregate functions above and examples in the end, looks 
enough,let me move it




----------------------------------------------------------------
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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to