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