Thanks Devopam , I did not get your point, could you pls show me a dummy query in my case
Regards On Wed, Oct 15, 2014 at 1:42 PM, Devopam Mittra <[email protected]> wrote: > 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 <[email protected]> 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 > > >
