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
