Windowing functions (known also as analytics) allow to compute:
They are distinguished from ordinary SQL functions by the presence of an OVER clause.
With windowing aggregate functions, you can calculate moving and cumulative versions of SUM, AVERAGE, COUNT, MAX, MIN, and many more functions.
Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of rows is called a window.
Analytic functions enable you to calculate:
Analytic functions can be used in the following areas where standard SQL fails to impress.
Partition in the clause statement define the subset.
The data property dense/parse is really important when using this functions.
Analytic functions allow to replace procedural by set based logic.
True streaming platform (not microbatch) will handles late arriving data. The window is never really closed and some late arriving data with a timestamp inside the window can arrive at any time.
Query processing using analytic functions takes place in three stages :
List of analytic functions