hi Yogesh, Please try to leverage common table expression (WITH ...) to achieve your desired outcome
regards Dev > On Oct 15, 2014, at 1:18 PM, yogesh dhari <yogeshh...@gmail.com> wrote: > > 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 >
