Categories

Apr 24 in Big Data | Hadoop

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

Related questions

Madanswer
Apr 24 in Big Data | Hadoop
Apr 24 in Big Data | Hadoop
Apr 6 in Big Data | Hadoop
...