Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> NOT IN clause in Hive


Copy link to this message
-
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 is null.

Phil.

On 14 August 2012 10:20, Bertrand Dechoux <[EMAIL PROTECTED]> 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
> <[EMAIL PROTECTED]> 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