frame_exact¶
Description¶
Specify the exact relative time frame for a window context. This is the exact version of frame(), where the window frame start and end times are exactly “Valid From” minus “back” and “Valid To” plus “ahead”. Evaluation of exact window frames can be slow when the data volume is large.
Return type¶
frame
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
frame_exact( [ backOrAhead ] ... )
Argument |
Type |
Required |
Multiple |
---|---|---|---|
backOrAhead |
expression |
Optional |
Can be multiple |
Examples¶
make_col avg:window(avg(load), group_by(host), order_by(time), frame_exact(back:10m))
Compute the moving average of system load within the past 10 minutes of each event