Question: what is semi join in hive?
Answer: The left semi join is used in place of the IN / EXISTS sub-query in Hive. ... In the left semi join, the right-hand side table can only be used in the join clause but not in the WHERE or the SELECT clause.