Hive Join

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

Employee department table hive DML operation

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); 