PLEASE HELP :: HOW TO DO INNER JOIN IN HIVE

[yogesh dhari]

Hello all,

I have a use case where I need to do inner join..

Like

select A.iteam , B.Decsription,
from iteam_table A INNER JOIN iteam_desc B
on A.id = B.id


As hive does not support Inner Join,

Please suggest how to do it


Thanks in Advance