What is Emi Outer Join in Hive?

Question

Semi Join

In RDBMS, you use IN and EXISTS subquery, but here, LEFT SEMI JOIN is used as a replacement to it.

hive> select * 
    > from product
    > left semi join sales on(sales.id=product.id);
Output:-
2    Coat

3    Pencil

4    Shirt

5    Shoes