The join prefix joins the loaded table with an existing named table or the last previously created data table.
[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.
|tablename||The named table to be compared to the loaded table.|
|loadstatement or selectstatement||The LOAD or SELECT statement for the loaded table.|
Join LOAD * from abc.csv;
Join SELECT * from table1;
LOAD * from file1.csv;
LOAD * from file2.csv;
.. .. ..
join (tab1) LOAD * from file3.csv;