leftjoin

Type of operation: Join

Description

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

Usage

leftjoin [ targetDataset ] [ , predicate ] ... [ , columnbinding ] ...

Argument

Type

Required

Multiple

targetDataset

datasetref

Optional

Only one

predicate

bool

Optional

Can be multiple

columnbinding

expression

Optional

Can be multiple

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 [email protected], 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.