Advantages and disadvantages of using map side join in hive

This is for Hadoop eco system like HDFS, Map reduce, Hive, Hbase, Pig, sqoop,sqoop2, Avro, solr, hcatalog, impala, Oozie, Zoo Keeper and Hadoop distribution like Cloudera, Hortonwork etc.
forum_admin
Site Admin
Posts: 185
Joined: Wed Jul 16, 2014 9:22 pm
Contact:

Advantages and disadvantages of using map side join in hive

Postby forum_admin » Sat Sep 24, 2016 9:05 pm

what are the Advantages and disadvantages of using map side join in hive?


Guest

Re: Advantages and disadvantages of using map side join in hive

Postby Guest » Sat Sep 24, 2016 10:05 pm

Advantages of using map side join:
⦁ Map-side join helps in minimizing the cost that is incurred for sorting and merging in the shuffle and reduce stages.
⦁ Map-side join also helps in improving the performance of the task by decreasing the time to finish the task.

Disadvantages of Map-side join:
⦁ Map side join is adequate only when one of the tables on which you perform map-side join operation is small enough to fit into the memory.  Hence it is not suitable to perform map-side join on the tables which are huge data in both of them.


Return to “Hadoop and Big Data”

Who is online

Users browsing this forum: No registered users and 2 guests