You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2020/04/15 18:37:10 UTC
[GitHub] [spark] viirya commented on a change in pull request #28220:
[SPARK-31390][SQL][DOCS] Document Window Function in SQL Syntax Section
viirya commented on a change in pull request #28220: [SPARK-31390][SQL][DOCS] Document Window Function in SQL Syntax Section
URL: https://github.com/apache/spark/pull/28220#discussion_r409052611
##########
File path: docs/sql-ref-syntax-qry-window.md
##########
@@ -19,4 +19,208 @@ license: |
limitations under the License.
---
-**This page is under construction**
+### Description
+
+Similarly to aggregate functions, window functions operate on a group of rows. However, unlike aggregate functions, window functions perform aggregation without reducing, calculating an aggregated value for each row in the specified window. Window functions are useful for processing tasks such as calculating a moving average, computing a cumulative, or accessing the value of rows given the relative position of the current row. Spark SQL supports three types of window functions:
Review comment:
"without reducing"? Sounds confusing. How about "without reducing the number of rows"?
And "but calculating an aggregated value for each row in the specified window."
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org