Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:In-Reply-To:X-Apple-Yahoo-Original-Message-Folder:Mime-Version:Content-Type:Content-Transfer-Encoding:Message-Id:X-Mailer:From:X-Apple-Yahoo-Replied-Msgid:Subject:Date:To;
  b=HvD/wXVh4sYdK+A4qSOKAyUg3RjP2qx8JAAaZutjxmaKsvHo7JshiAkGDAm5BHrOWxcHTSyY3sSGLmLcWiSZMIHbmUVIOAOxSzjNrd99tOcVE2ux87gxQ5N8K3ziYGmuofPNyl3SAanletDFy8NBcoOMOOspPHXoHh/p99LQeSQ=
  ;
References: 
 <CADUKBnv7S8KP0H6XUn4TofbVZSVguPQKGSheFZpq4krvE7PSVw@mail.gmail.com>
In-Reply-To: 
 <CADUKBnv7S8KP0H6XUn4TofbVZSVguPQKGSheFZpq4krvE7PSVw@mail.gmail.com>
Mime-Version: 1.0 (iPhone Mail 8L1)
Content-Type: multipart/alternative;
	boundary=Apple-Mail-4--135782804
Content-Transfer-Encoding: 7bit
Message-Id: <4595A1CF-6A55-4F6B-9CE2-57559590C0FA@yahoo.com>
From: Ayon Sinha <ayonsinha@yahoo.com>
Subject: Re: Hive: Issue with JOIN on tables in a database namespace
Date: Sat, 19 Nov 2011 21:59:56 -0800
To: "user@hive.apache.org" <user@hive.apache.org>


--Apple-Mail-4--135782804
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

Have you tried using table aliases? What errors do you see?

Sent from my iPhone

On Nov 19, 2011, at 8:44 PM, Daniel Godfrey <c.daniel.godfrey@gmail.com> wro=
te:

> Hey everyone,=20
>=20
> I'm having issues trying to execute a simple join on two tables that are i=
n the same database namespace. I'm trying to following:
>=20
> SELECT namespace.table1.* FROM namespace.table1 JOIN namespace.table2 ON (=
namespace.table1.field1 =3D namespace.table2.field2);
>=20
> If I move the tables outside of the database namespace, I can perform the j=
oin just fine.=20
>=20
> Is it not possible to join tables within a database? Or am I missing somet=
hing?
>=20
> Cheers,=20
>=20
> --=20
> C. Daniel Godfrey
>=20
> -4th Year Software Engineering Student at the University of Ottawa
>=20
>=20

--Apple-Mail-4--135782804
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=utf-8

<html><body bgcolor="#FFFFFF"><div>Have you tried using table aliases? What errors do you see?<br><br>Sent from my iPhone</div><div><br>On Nov 19, 2011, at 8:44 PM, Daniel Godfrey &lt;<a href="mailto:c.daniel.godfrey@gmail.com">c.daniel.godfrey@gmail.com</a>&gt; wrote:<br><br></div><div></div><blockquote type="cite"><div><span class="Apple-style-span" style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">Hey everyone,&nbsp;</span><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">
<br></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">I'm having issues trying to execute a simple join on two tables that are in the same database namespace. I'm trying to following:</div>
<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); "><br></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">
SELECT namespace.table1.* FROM namespace.table1 JOIN namespace.table2 ON (namespace.table1.field1 = namespace.table2.field2);</div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">
<br></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">If I move the tables outside of the database namespace, I can perform the join just fine.&nbsp;</div>
<div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); "><br></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">
Is it not possible to join tables within a database? Or am I missing something?</div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">
<br></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 13px; background-color: rgba(255, 255, 255, 0.917969); ">Cheers,&nbsp;</div><div><br></div>-- <br>C. Daniel Godfrey<br><br><div>-4th Year Software Engineering Student at the University of Ottawa<br>
<br></div><br>
</div></blockquote></body></html>
--Apple-Mail-4--135782804--