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

targetDataset

datasetref

Optional

Only one

predicate

bool

Optional

Can be multiple

columnbinding

expression

Optional

Can be multiple

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 [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.