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