Return-Path: 
 <hive-user-return-3020-apmail-hadoop-hive-user-archive=hadoop.apache.org@hadoop.apache.org>
Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org
Received: (qmail 11048 invoked from network); 30 Apr 2010 07:41:11 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 30 Apr 2010 07:41:11 -0000
Received: (qmail 80629 invoked by uid 500); 30 Apr 2010 07:14:29 -0000
Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org
Received: (qmail 80406 invoked by uid 500); 30 Apr 2010 07:14:27 -0000
Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:hive-user-help@hadoop.apache.org>
List-Unsubscribe: <mailto:hive-user-unsubscribe@hadoop.apache.org>
List-Post: <mailto:hive-user@hadoop.apache.org>
List-Id: <hive-user.hadoop.apache.org>
Reply-To: hive-user@hadoop.apache.org
Delivered-To: mailing list hive-user@hadoop.apache.org
Received: (qmail 80397 invoked by uid 99); 30 Apr 2010 07:14:27 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Apr 2010 07:14:27 +0000
X-ASF-Spam-Status: No, hits=2.9 required=10.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [74.125.83.48] (HELO mail-gw0-f48.google.com) (74.125.83.48)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Apr 2010 07:14:21 +0000
Received: by gwj20 with SMTP id 20so466295gwj.35
        for <hive-user@hadoop.apache.org>;
 Fri, 30 Apr 2010 00:14:00 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.150.187.16 with SMTP id k16mr1032017ybf.311.1272611640141;
	Fri, 30 Apr 2010 00:14:00 -0700 (PDT)
Received: by 10.100.7.3 with HTTP; Fri, 30 Apr 2010 00:14:00 -0700 (PDT)
In-Reply-To: <x2mdfdaa57e1004300013x42aa4bc9qdb6be1ad99f1d52b@mail.gmail.com>
References: <h2jdfdaa57e1004300011p1fb75760id81985e900a00575@mail.gmail.com>
	 <x2mdfdaa57e1004300013x42aa4bc9qdb6be1ad99f1d52b@mail.gmail.com>
Date: Fri, 30 Apr 2010 16:14:00 +0900
Message-ID: <m2sdfdaa57e1004300014i7180782cjc1e8cc4483028363@mail.gmail.com>
Subject: error: Both Left and Right Aliases Encountered in Join obj
From: Harshit Kumar <kumar@bike.snu.ac.kr>
To: hive-user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=000e0cd6a792bf6ad004856efc2f

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

Hi

I have a query like this

from spo t1 join spo t2 on (t1.sub=t2.sub and t1.obj<>t2.obj) insert
overwrite table spojoin select t1.sub, t1.pre, t2.obj, t2.sub, t2.pre,
t2.obj;

Executing the above query gives the following error.
*FAILED: Error in semantic analysis: line 1:46 Both Left and Right Aliases
Encountered in Join obj*

However, If I replace the <> operator with == operator, it executes.

Please let me know what am I doing wrong?

Thanks
Kumar

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

<div class=3D"gmail_quote"><div><div class=3D"h5"><div class=3D"gmail_quote=
">Hi<br><br>I have a query like this<br><br>from spo t1 join spo t2 on (t1.=
sub=3Dt2.sub and t1.obj&lt;&gt;t2.obj) insert overwrite table spojoin selec=
t t1.sub, t1.pre, t2.obj, t2.sub, t2.pre, t2.obj;<br>

<br>Executing the above query gives the following error.<br>
<b>FAILED: Error in semantic analysis: line 1:46 Both Left and Right Aliase=
s Encountered in Join obj</b><br><br>However, If I replace the &lt;&gt; ope=
rator with =3D=3D operator, it executes. <br><br>Please let me know what am=
 I doing wrong?<br>


<br>Thanks <br><font color=3D"#888888">Kumar<br>
</font></div><br>
</div></div></div><br>

--000e0cd6a792bf6ad004856efc2f--