in Big Data | Hadoop by
Q:
Full Outer Join

Full Outer Join gives the output as rows for each row from both tables.

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

Kurt 	0	NULL	NULL
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
0 votes
asked Apr 7, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
0 votes
asked Jun 14, 2020 in Hive by Robindeniel
0 votes
...