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