SEMI is only for exist. Maybe you can try this Select a.* FROM tblA a left outer JOIN tblB b ON a.field1 = b.field1 where a.field2 is null or b.fild2 is null
Best regards Ransom. -----Original Message----- From: Philip Tromans [mailto:philip.j.trom...@gmail.com] Sent: Wednesday, April 11, 2012 9:02 PM To: user@hive.apache.org Subject: Re: Does Hive supports EXISTS keyword in select query? Hi, Hive supports EXISTS via SEMI JOIN. Have a look at: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins Cheers, Phil. On 11 April 2012 13:59, Bhavesh Shah <bhavesh25s...@gmail.com> wrote: > Hello all, > I want to query like below in Hive: > Select a.* FROM tblA a JOIN tblB b ON a.field1 = b.field1 > where (a.field2 is null or not exists(select field2 from tblB where filed2 > is not null) > > But I think Hive doesn't supports EXISTS keyword so how can I overcome this > issue? > Pls suggest me some solution to this. I just got this kind of situation > where I need to implement some thing like EXISTS/NOT EXISTS > > > > -- > Thanks and Regards, > Bhavesh Shah >