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