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

Reply via email to