Join
The join prefix joins the loaded table with an existing named table or the last previously created data table.
Syntax:
[inner | outer | left | right ]Join [ (tablename ) ]( loadstatement | selectstatement )
The join is a natural join made over all the common fields. The join statement may be preceded by one of the prefixes inner, outer, left or right.
Arguments:
Argument | Description |
---|---|
tablename | The named table to be compared to the loaded table. |
loadstatement or selectstatement | The LOAD or SELECT statement for the loaded table. |
Example:
Join LOAD * from abc.csv;
Join SELECT * from table1;
tab1:
LOAD * from file1.csv;
tab2:
LOAD * from file2.csv;
.. .. ..
join (tab1) LOAD * from file3.csv;