update_resource

Type of operation: Join

Description

Update the current resource by merging an event (or point) table with it.

Usage

update_resource [ options ], pkequalitypredicate ..., columnbinding ...

Argument

Type

Required

Multiple

options

options

Optional

Only one

pkequalitypredicate

bool

Required

Can be multiple

columnbinding

expression

Required

Can be multiple

Options

Option

Type

Meaning

expiry

duration

How long state updates from the input events live for, before they revert to null (default 1h)

Accelerable

update_resource is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs, can be accelerated, making queries on the dataset respond faster.

Examples

update_resource options(expiry:duration_hr(1)), [email protected], cpu:@cpuload.load

Look up the ‘host_uid’ value as the ‘host’ column in the event table named ‘cpuload’, and extract the ‘load’ column from that ‘cpuload’ table, calling the new column ‘cpu’ in the output resource.

Aliases

  • mergeevent (deprecated)

  • merge_event (deprecated)