https://community.cloudera.com/t5/Support-Questions/Overwriting-a-column-in-HIVE/m-p/109600#M72450 <P>FROM salary employees will syntax above alias the salary table as employees. I guess your query needs to join on employees table with left or inner join? Also you will probably not want to overwrite the table you are selecting from?</P><P>INSERT OVERWRITE TABLE employees SELECT employees.&lt;all columns but salary_date&gt;, salary.salary_date FROM salary inner join employees on salary.employee_number = employee.employee_number;</P> Fri, 22 Apr 2016 09:10:21 GMT andrew_sears 2016-04-22T09:10:21Z