https://community.cloudera.com/t5/Support-Questions/Overwriting-a-column-in-HIVE/m-p/109597#M72447 <P>Hello there,</P><P>I need to overwrite a column in a HIVE table with data from another HIVE table.</P><P>In my exemple I have a a table employees and a table salary. I need to overwrite just ONE column of the employees table....let's a say a from start_date with values from called salary_date in the salary table. Both salary and employees table have a a common key which is the coluns employee_number. </P><P>Here is what I have been trying to do without success. </P><P> INSERT OVERWRITE TABLE employees SELECT employees.start_date salary.salary_date FROM salary employees WHERE salary.employee_number = employee.employee_number</P><P>Any insights on where I might be making a mistake here would help. I see some exemples suggesting to use partitions but I am not sure how to use this in this case, as I am considering to overwrite the whole start_date column and not just some values. </P><P>Thanks!</P><P>Wellington</P> Thu, 21 Apr 2016 18:14:17 GMT junnnninho 2016-04-21T18:14:17Z