uter join?
>
> Thanks and Regards,
> Prakrati
>
> -Original Message-
> From: Philip Tromans [mailto:philip.j.trom...@gmail.com]
> Sent: Tuesday, August 14, 2012 2:55 PM
> To: user@hive.apache.org
> Subject: Re: NOT IN clause in Hive
>
> Hive doesn't support
uter join?
>
> Thanks and Regards,
> Prakrati
>
> -Original Message-
> From: Philip Tromans [mailto:philip.j.trom...@gmail.com]
> Sent: Tuesday, August 14, 2012 2:55 PM
> To: user@hive.apache.org
> Subject: Re: NOT IN clause in Hive
>
> Hive doesn't support IN. Yo
-
> From: Philip Tromans [mailto:philip.j.trom...@gmail.com]
> Sent: Tuesday, August 14, 2012 2:55 PM
> To: user@hive.apache.org
> Subject: Re: NOT IN clause in Hive
>
> Hive doesn't support IN. You'll need to rewrite your query as a left outer
> join, and check whether the RHS i
Dear Phil,
Can you be a liitle more specific about using the left outer join?
Thanks and Regards,
Prakrati
-Original Message-
From: Philip Tromans [mailto:philip.j.trom...@gmail.com]
Sent: Tuesday, August 14, 2012 2:55 PM
To: user@hive.apache.org
Subject: Re: NOT IN clause in Hive
Hive
Hive doesn't support IN. You'll need to rewrite your query as a left
outer join, and check whether the RHS is null.
Phil.
On 14 August 2012 10:20, Bertrand Dechoux wrote:
> According to the error message, you are not using the correct synthax :
> https://cwiki.apache.org/confluence/display/Hive/
According to the error message, you are not using the correct synthax :
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-ALLandDISTINCTClauses
Bertrand
On Tue, Aug 14, 2012 at 11:12 AM, Prakrati Agrawal <
prakrati.agra...@mu-sigma.com> wrote:
> Dear al
Hi Puneet
The IN clause is available in latest versions of hive. (I checked in 0.9).
In your projected scenario, You can induce the functionality of NOT IN clause as
select * from customer whereNOT(cust_id =12022 OR cust_id=11783);
Similarly you can do it for IN clause, just avoid NOT in above
