Re: Hive support for NOT IN

Rewrite the query as- Where NOT col name IN (subquery) Thanks, Vinod On Wed, Nov 28, 2012 at 11:47 AM, Venugopal Krishnan < venugopal_krish...@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

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.