There are 4 different types of joins in HiveQL –
JOIN- It is very similar to Outer Join in SQL
FULL OUTER JOIN – This join Combines the records of both the left and right outer tables. Basically, that fulfill the join condition.
LEFT OUTER JOIN- Through this Join, All the rows from the left table are returned even if there are no matches in the right table.
RIGHT OUTER JOIN – Here also, all the rows from the right table are returned even if there are no matches in the left table.