Stream - Windows
About
SQL Function - Window Aggregate (Analytics function) in Stream
Articles Related
Type
Two type:
Aggregation
Example: find the minimum and maximum each minute
Window
windowed analytics (sliding windows) (same as SQL Function - Window Aggregate (Analytics function) ?)
an output record (or row) is produced for each new input record.
an output record for each and every new input record for the specific PARTITION
Each field (or column) in the output record may be calculated using a different window or partition.
Windows definition can be time or row-based.
Example: find the minimum and maximum in the 60 second period prior to any given reading