documentationjoin¶
Type of operation: Join
Description¶
Temporal inner join, adding new columns in the output dataset.
Usage¶
join [ targetDataset ], [ predicate_1, predicate_2, ... ], [ columnbinding_1, columnbinding_2, ... ]
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
@targetDataset |
datasetref |
yes |
no |
none |
predicate |
bool |
yes |
yes |
none |
columnbinding |
expression |
yes |
yes |
none |
Accelerable¶
join 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¶
join on([email protected]), hostname:@host.name
Temporal inner join with dataset ‘host’, and extract the ‘name’ column from that ‘host’ table, calling the new column ‘hostname’ in the output.
join on(timestamp <= @hostlogs.timestamp, frame(ahead:1s, back:1s)), hostlog:@hostlogs.log
Temporal inner join with dataset ‘hostlogs’, using frame to look 1 second ahead and 1 second behind the original timestamp. Logs from the hostlog dataset are extracted as a new column if their timestamp is less than or equal to the timestamp of this dataset’s log. The new column is called ‘hostlog’ in the output.