fulljoin

Type of operation: Join

Description

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

Usage

fulljoin [ @targetDataset ], [ predicate_1, predicate_2, ... ], [ columnbinding_1, columnbinding_2, ... ]

Argument	Type	Optional	Repeatable	Restrictions
@targetDataset	dataset	yes	no	dataset
predicate	bool	yes	yes	none
columnbinding	expression	yes	yes	none

Options

Option	Type	Meaning
ntrhs	bool
ntrhs	bool

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.