https://community.cloudera.com/t5/Support-Questions/Overwriting-a-column-in-HIVE/m-p/109598#M72448 <P>You cannot overwrite one column you need to recreate the whole table. Like in the CTAS discussion we had. So if your employees table has 10 columns you need something like</P><P>INSERT OVERWRITE TABLE employees SELECT employees.&lt;all columns but salary_date&gt;, salary.salary_date FROM salary employees WHERE salary.employee_number = employee.employee_number;</P><P>You also need to order the columns correctly like:</P><P>select e.id, e.date,salary.salary_date,e.name,e.lastname. .... </P> Thu, 21 Apr 2016 18:36:15 GMT bleonhardi 2016-04-21T18:36:15Z