0 votes
in Big Data | Hadoop by

Right Outer Join

Right Outer Join gives the output as the rows from the right table.

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

Cena 	2	2	Coat

Angle 	3	3	Pencil

Raffle 	4	4	Shirt

John 	5	5	Shoes

Related questions

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