You can apply a window specification to an aggregate function. The following window types are supported for user-defined aggregate functions.
Window Type | Aggregation Group | Supported Partitioning Strategy |
---|---|---|
Reporting window | ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING | Hash partitioning |
Cumulative window |
|
Hash partitioning |
Moving window |
|
Hash partitioning and range partitioning |