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
Dear all,
I am trying to execute this query : SELECT distinct(buyerid) from transaction
WHERE buyerid NOT IN(SELECT distinct(sellerid) from transaction)
This gives me the following error:
FAILED: Parse Error: line 1:59 cannot recognize input near 'SELECT' 'distinct'
'(' in expression specificat
above query
select * from customer where (cust_id =12022 OR cust_id=11783);
Regards
Bejoy KS
From: Puneet Khatod
To: "user@hive.apache.org"
Sent: Wednesday, July 18, 2012 2:11 PM
Subject: Not in clause in hive query
Hi,
I am working on Hive
Hi,
I am working on Hive 0.7. I am migrating SQL queries to hive and facing issues
with the queries that have 'Not in' clause usage.
Example:
select * from customer where cust_id not in (12022,11783);
I am getting:
FAILED: Parse Error: line 1:38 cannot recognize input near ' cust_id ' 'not'
'
