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

Related questions

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
0 votes
asked Jan 13, 2020 in Big Data | Hadoop by AdilsonLima
0 votes
asked Apr 8, 2020 in Big Data | Hadoop by GeorgeBell
+1 vote
asked May 7, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
asked Jun 14, 2020 in Hive by Robindeniel
0 votes
...