full-join
Keep every row of both x and y, matching on the key columns.
NoteExperimental
This function is experimental; its interface may change without notice.
Since 0.6.0.
Matched rows combine as in left-join; a y row with no match becomes a new output row with its key columns and none in x’s non-key columns.
Usage
full-join(
x,
y,
by: none,
)Parameters
| Parameter | Default | Description |
|---|---|---|
x |
Left dataset (row-store or column-store). | |
y |
Right dataset (row-store or column-store). | |
by |
none |
Key columns: none for the common columns, a name, or an array. |
Returns
A row-store array of every row from both inputs.