hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From विनोद सिंह <vi...@vinodsingh.com>
Subject Re: Hive support for NOT IN
Date Wed, 28 Nov 2012 06:47:18 GMT
Rewrite the query as-

Where NOT col name IN (subquery)

Thanks,
Vinod

On Wed, Nov 28, 2012 at 11:47 AM, Venugopal Krishnan <
Venugopal_Krishnan@mindtree.com> wrote:

>  Hi ,
>
>
>
> I want to know if HIVE supports NOT IN / IN clauses like oracle and other
> databases support. If it’s not then do we have any alternative .
>
>
>
> Query is
>
>
>
> Main query
>
> Where col name NOT IN (subquery)
>
>
>
>
>
> *Regards,*
>
> *Venugopal*
>
>
>
> ------------------------------
>
> http://www.mindtree.com/email/disclaimer.html
>

Mime
View raw message