in Big Data | Hadoop by
Q:
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
Learn More with Madanswer

Related questions

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
...