hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Thusoo <>
Subject RE: Using join statement
Date Fri, 06 Feb 2009 13:31:31 GMT
Can you give out the data sets..

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

From: Amandeep Khurana []
Sent: Friday, February 06, 2009 3:43 AM
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=b.y);

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

Where am I going wrong?


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

View raw message