joins in hql is similar to sql join which means combines two or more tables. difference between ma side join and join in hql is that when we perform join operation then that particular job or task will be assigned to the mapreduce task where both the map stage and reduce stage will be executed. when we use map side join all the tasks or jobs will be performed by mapper alone. It is mainly suitable for small tables to optimize the task.