rollup()
Combine multiple heartbeat aggregates
Combine multiple heartbeat aggregates into one. This can be used to combine aggregates into adjacent intervals into one
larger interval, such as rolling daily aggregates into a weekly or monthly aggregate. All the aggregates must have the
same heartbeat_liveness.
Another use for this is to combine heartbeat aggregates for redundant systems to determine if there were any overlapping failures. For instance, a master and standby system can have their heartbeats combined to see if there were any intervals where both systems were down at the same time. The result of rolling overlapping heartbeats together like this is a heartbeat aggregate which considers a time live if any of its component aggregates were live.
Arguments
Section titled “Arguments”The syntax is:
rollup( heartbeatagg HeartbeatAgg) RETURNS HeartbeatAgg| Name | Type | Default | Required | Description |
|---|---|---|---|---|
| heartbeatagg | HeartbeatAgg | - | ✔ | The heartbeat aggregates to roll up |
Returns
Section titled “Returns”| Column | Type | Description |
|---|---|---|
| rollup | HeartbeatAgg | A heartbeat aggregate covering the interval from the earliest start time of its component aggregates to the latest end time. It combines the live ranges of all the components |