leftjoin [@targetDataset]?, [predicate: bool]*, [columnbinding: expression]*

Temporal left join, adding new columns in the output dataset.

Categories

• Join

Accelerable

leftjoin 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

leftjoin on(host_uid=@host.uid), hostname:@host.name

Temporal left join with dataset 'host', and extract the 'name' column from that 'host' table, calling the new column 'hostname' in the output.