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 <decho...@gmail.com> wrote: > 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 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 specification >> >> >> >> How can I rectify the query to get it working? >> >> >> >> Thanks and Regards, >> >> Prakrati >> >> >> ________________________________ >> This email message may contain proprietary, private and confidential >> information. The information transmitted is intended only for the person(s) >> or entities to which it is addressed. Any review, retransmission, >> dissemination or other use of, or taking of any action in reliance upon, >> this information by persons or entities other than the intended recipient is >> prohibited and may be illegal. If you received this in error, please contact >> the sender and delete the message from your system. >> >> Mu Sigma takes all reasonable steps to ensure that its electronic >> communications are free from viruses. However, given Internet accessibility, >> the Company cannot accept liability for any virus introduced by this e-mail >> or any attachment and you are advised to use up-to-date virus checking >> software. > > > > > -- > Bertrand Dechoux
