hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohit Anchlia <mohitanch...@gmail.com>
Subject HIVE NOT EXISTS
Date Mon, 01 Oct 2012 20:42:42 GMT
Could someone help me understand what alternative do I have for this query?
I am trying to check if a given row exists in the table.

select "",a.pagename,a.pagedetail,"",a.pagetitle,a.page_id,a.pagetype
  from page_temp_ext a
where 0 = (select count(*) from page_temp b where a.pagename = b.pagename
and a.pagetitle = b.pagetitle and a.page_id = b.pageid and a.pagetype =
b.pagetype);

Mime
View raw message