Hive Join

Let's see two tables Employee and EmployeeDepartment that are going to be joined.

Inner joins

Select  *  from employee join employeedepartment  ON (employee.empid=employeedepartment.empId)

Output : <<InnerJoin.png>>

Left outer joins

Select e.empId, empName, department from employee e Left outer join employeedepartment ed on(e.empId=ed.empId);

Output : <<LeftOuterJoin.png>>

Right outer joins

Select e.empId, empName, department from employee e Right outer join employeedepartment ed on(e.empId=ed.empId);

Full outer joins

Select e.empId, empName, department from employee e FULL outer join employeedepartment ed on(e.empId=ed.empId);

Hadoop Tutorial