Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-user@hadoop.apache.org
Received-SPF: softfail (nike.apache.org: transitioning domain of
 athusoo@facebook.com does not designate 69.63.179.25 as permitted sender)
From: Ashish Thusoo <athusoo@facebook.com>
To: "hive-user@hadoop.apache.org" <hive-user@hadoop.apache.org>
Date: Fri, 6 Feb 2009 05:31:31 -0800
Subject: RE: Using join statement
Thread-Topic: Using join statement
Thread-Index: AcmIUEJVW/85t4o7TOOAOZzyHnTTDwADvak5
Message-ID: 
 <68B7689C98024D43B4C2709456F0B5200966124A37@SC-MBXC1.TheFacebook.com>
References: <35a22e220902060343u5c707415s1d67ddfbeaf076cf@mail.gmail.com>
In-Reply-To: <35a22e220902060343u5c707415s1d67ddfbeaf076cf@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Can you give out the data sets..

also look at the dfs files created for table c and see if any files were cr=
eated. Chances are that the join did not produce anything.

Ashish
________________________________________
From: Amandeep Khurana [amansk@gmail.com]
Sent: Friday, February 06, 2009 3:43 AM
To: hive-user@hadoop.apache.org
Subject: Using join statement

I am trying to join two tables using the following query:

insert overwrite table c select a.x, a.y, b.z  from a join b on (a.y=3Db.y)=
;

Its not putting anything into the table c. If I just simply write the selec=
t command, it throws nothing onto the screen.

Where am I going wrong?

Amandeep


Amandeep Khurana
Computer Science Graduate Student
University of California, Santa Cruz