frame

Description

Specify the approximate relative time frame for a window context. The frame starts from the current row’s “Valid From” time minus “back”, and ends at “Valid From” plus “ahead” (both ends are inclusive). For better performance, the window frame boundaries may not be exact and can deviate by at most 1/120th of the total frame size (or 10 seconds, whichever is larger). To make the window boundaries exact, at the cost of slower performance, use the frame_exact() function.

Return type

frame

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

frame( [ 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(back:10m))

Compute the moving average of system load within the past 10 minutes of each event