You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Venugopal Krishnan <Ve...@mindtree.com> on 2012/11/28 07:17:37 UTC

Hive support for NOT IN

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

Re: Hive support for NOT IN

Posted by विनोद सिंह <vi...@vinodsingh.com>.

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
>