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
