Hive Types Of Joins in Big Data Hadoop

1.Shuffle Join

2.Map Join(Broardcast Join)

3.Bucket Map Join

4.Sort Merge Bucket(SMB) Map Join

5. Skew Join

** Join operation is processed at reduce phase. Based on those join methods, Hive uses various optimization techniques to improve the performance.