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