hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogesh dhari <yogeshh...@gmail.com>
Subject Re: PLEASE HELP :: HOW TO DO INNER JOIN IN HIVE
Date Wed, 15 Oct 2014 08:19:35 GMT
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 <devopam@gmail.com> 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 <yogeshhive@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
> >
>

Mime
View raw message