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.
Ashish ________________________________________ From: Amandeep Khurana [[email protected]] Sent: Friday, February 06, 2009 3:43 AM To: [email protected] 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 Amandeep Khurana Computer Science Graduate Student University of California, Santa Cruz
