Return-Path: 
 <user-return-10149-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 AD11BD799
	for <apmail-hive-user-archive@www.apache.org>;
 Wed, 29 Aug 2012 21:44:55 +0000 (UTC)
Received: (qmail 73460 invoked by uid 500); 29 Aug 2012 21:44:54 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 73355 invoked by uid 500); 29 Aug 2012 21:44:54 -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 73347 invoked by uid 99); 29 Aug 2012 21:44:54 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Aug 2012 21:44:54 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of sonia.gehlot@gmail.com
 designates 74.125.82.54 as permitted sender)
Received: from [74.125.82.54] (HELO mail-wg0-f54.google.com) (74.125.82.54)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Aug 2012 21:44:48 +0000
Received: by wgx1 with SMTP id 1so701644wgx.23
        for <user@hive.apache.org>; Wed, 29 Aug 2012 14:44:26 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:from:date:message-id:subject:to:content-type;
        bh=EWbOkZBm5qfJL61G5sQxrOq9VpZ/ZwbYo4kPjBMCOVY=;
        b=s/P8zYESOrnYo46wKF/emBDah+PrQznq9Q940MS5/FbR6QwSyKA5OKTw5GyWYYA+AF
         zCuAzL0zev8C7pPNSePJRL5wOjAO72tuf0ni0t8RC92N3Nt1hr0c2St8D9uegIsJTbVl
         NJgDdpzca2zDKjlHBCzOPHtIy8W9R/C/dUcinjBOYMD+XnZ9miMsYLyPiKblc3RyOZJF
         Qqkj3mvgqQdqyOTbrw6tYGwv8f0JmwDt4f7zSmpU+wkRevHi24qk+RBG6FWwTy7/WQIn
         ZwRmID6aWHjOoJYsH71DGn3X7ZxCV2LZX/K7Vrnnt8+KT/Z1p53dlxZx1h+ZrtDCNM2+
         t3DA==
Received: by 10.216.200.201 with SMTP id z51mr1740437wen.0.1346276666797; Wed,
 29 Aug 2012 14:44:26 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.227.146.80 with HTTP; Wed, 29 Aug 2012 14:44:06 -0700 (PDT)
From: sonia gehlot <sonia.gehlot@gmail.com>
Date: Wed, 29 Aug 2012 14:44:06 -0700
Message-ID: 
 <CANvpuE2cbwGn1uE1xH3EZ8EtLDHiMhRwZCk=TCAU0Ex5v-buyA@mail.gmail.com>
Subject: Join with OR condition in hive
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=0016e6dd893b7e6e8e04c86e7639
X-Virus-Checked: Checked by ClamAV on apache.org

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

Hi All,

I am joining 2 tables in hive, with or condition. for example:

select blah
from table a
Join table b
*on (a.col1 = b.col2 or a.col2 = 0)*
*
*
but this is giving me error that OR not supported in hive currently.

Any suggestion how I can handle this in hive query.

Thanks,
Sonia

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

Hi All,<div><br></div><div>I am joining 2 tables in hive, with or condition=
. for example:</div><div><br></div><div>select blah=A0</div><div>from table=
 a</div><div>Join table b</div><div><b>on (a.col1 =3D b.col2=A0or a.col2 =
=3D 0)</b></div>

<div><b><br></b></div><div>but this is giving me error that OR not supporte=
d in hive currently.</div><div><br></div><div>Any suggestion how I can hand=
le this in hive query.</div><div><br></div><div>Thanks,</div><div>Sonia</di=
v>


--0016e6dd893b7e6e8e04c86e7639--