title: Hive query optimization with map join
body: <p>I have a table with 11 gb of data and the other one with 130 gb of data , and  I am doing the  update  operation , Can i use map join in hive to improve query execution optimization ? Please suggest the useful information regarding this .</p>