To see how Hive executed a JOIN operation, use the _ statement and look for the _ value.
QUERY; JOIN Operator
EXPLAIN; JOIN Operator
QUERY; MAP JOIN Operator
EXPLAIN; MAP JOIN Operator