Join multple TABLES in mapper side, called map side join. PLEASE note mapside join should has strict FORMAT and sorted properly. If dataset is smaller tables, goes through reducer phrase. Data should partitioned properly.

Join the MULTIPLE tables in reducer side called reduce side join. If you have large amount of data tables, planning to join both tables. One table is large amount of rows and columns, another one has few number of tables only, goes through Rreduce side join. It’s the best WAY to join the multiple tables

Join multple tables in mapper side, called map side join. Please note mapside join should has strict format and sorted properly. If dataset is smaller tables, goes through reducer phrase. Data should partitioned properly.

Join the multiple tables in reducer side called reduce side join. If you have large amount of data tables, planning to join both tables. One table is large amount of rows and columns, another one has few number of tables only, goes through Rreduce side join. It’s the best way to join the multiple tables