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)