Return-Path: 
 <user-return-10575-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-user-archive@www.apache.org
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id E9473DBE2
	for <apmail-hive-user-archive@www.apache.org>;
 Mon,  1 Oct 2012 20:43:10 +0000 (UTC)
Received: (qmail 73448 invoked by uid 500); 1 Oct 2012 20:43:09 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 73376 invoked by uid 500); 1 Oct 2012 20:43:09 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 73296 invoked by uid 99); 1 Oct 2012 20:43:09 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Oct 2012 20:43:09 +0000
X-ASF-Spam-Status: No, hits=3.1 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,SUBJ_ALL_CAPS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of mohitanchlia@gmail.com
 designates 209.85.223.176 as permitted sender)
Received: from [209.85.223.176] (HELO mail-ie0-f176.google.com)
 (209.85.223.176)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Oct 2012 20:43:03 +0000
Received: by ieak11 with SMTP id k11so15865898iea.35
        for <user@hive.apache.org>; Mon, 01 Oct 2012 13:42:42 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=FEnMBRyyoJa3bhPE73nb6CveLWT7mUwJZcSMtERkvYo=;
        b=dt1BUNzFj9XeXBoxfacgG4+cE0LHMQkV33NFPHFmr1dr9EuEHss5bMGFtVkwSR+VFY
         dDNs+bonUJXahL/2UIdQ5xcBrESKzloLZuUpVwPdaDGiFVzeVTX1ATq8lsWlsAGSPGR8
         utrSjj9hRZbsQ0CJAZtWsJ0Aptgd4nLvGNptgaReK7erIsD4chkWGSAHHddIGJm1UJf4
         PDXVpo2PXxWPvhhas1S3VREW+ggJi2r5VIF003OPZgN493M9UvSqYLYYRu9EIrnXU6xk
         h+55tBjR4ktd7QDyl4SXPKLmfJliUNoUnmcvvzvR2WYnSLrcJ2buDpKOnrtKgTF3QrxE
         rU/A==
MIME-Version: 1.0
Received: by 10.50.0.171 with SMTP id 11mr6993206igf.23.1349124162699; Mon, 01
 Oct 2012 13:42:42 -0700 (PDT)
Received: by 10.64.81.113 with HTTP; Mon, 1 Oct 2012 13:42:42 -0700 (PDT)
Date: Mon, 1 Oct 2012 13:42:42 -0700
Message-ID: 
 <CAOT3TWpMVVphru_TOG5s_iPekb2BLiMkMWiswXyHkMErFPheiQ@mail.gmail.com>
Subject: HIVE NOT EXISTS
From: Mohit Anchlia <mohitanchlia@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=e89a8f3bb13f79c18a04cb057262
X-Virus-Checked: Checked by ClamAV on apache.org

--e89a8f3bb13f79c18a04cb057262
Content-Type: text/plain; charset=ISO-8859-1

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);

--e89a8f3bb13f79c18a04cb057262
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Could someone help me understand what alternative do I have for this q=
uery? I am trying to check if a given row exists in the table.</div>
<div>=A0</div>
<div>select &quot;&quot;,a.pagename,a.pagedetail,&quot;&quot;,a.pagetitle,a=
.page_id,a.pagetype<br>=A0 from page_temp_ext a<br>where 0 =3D (select coun=
t(*) from page_temp b where a.pagename =3D b.pagename and a.pagetitle =3D b=
.pagetitle and a.page_id =3D b.pageid and a.pagetype =3D b.pagetype);<br>
</div>

--e89a8f3bb13f79c18a04cb057262--