documentationfulljoin¶
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.