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