in Big Data | Hadoop by
Q:
Left Outer Join

Left Outer Join will give results for every row present in the left table.

hive> select sales.*,product.* 
    > from sales 
    > left outer join 
    > product on (sales.id=product.id);

John 	5	5	Shoes

Cena 	2	2	Coat

Kurt 	0	NULL	NULL

Angle 	3	3	Pencil

Raffle 	4	4	Shirt

Related questions

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
0 votes
asked Apr 8, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
0 votes
asked Apr 7, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
asked Sep 9, 2019 in Spark Sql by ivor2019
0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
...