fulljoin

Type of operation: Join

Description

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

Usage

fulljoin [ targetDataset ] [ , predicate ] ... [ , columnbinding ] ...

Argument

Type

Required

Multiple

Constant

@targetDataset

datasetref

Optional

Only one

Variable

predicate

bool

Optional

Can be multiple

Variable

columnbinding

expression

Optional

Can be multiple

Variable

Accelerable

fulljoin 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

fulljoin on([email protected]), hostname:@host.name

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