hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bhavesh Shah <bhavesh25s...@gmail.com>
Subject Does Hive supports EXISTS keyword in select query?
Date Wed, 11 Apr 2012 12:59:52 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message