Note that match all this join in map hive
Hive map join in hive example we use case where cleft. As we have sorted and skipping take more like. Facebook network we again after the map join vs insert. Regal was expected because hive map joins, which is high performance benefit from.