https://community.cloudera.com/t5/Support-Questions/Overwriting-a-column-in-HIVE/m-p/109599#M72449 <P>Thanks for the clarifications, Benjamin. It makes sense. I did as you instructed and I am getting an error related to the salary.employee_number... I have checked the expression and all the naming seems accurate. Have you had this error?</P><P>Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:227 Invalid table alias or column reference 'salary': (possible column names are:.....</P> Fri, 22 Apr 2016 06:19:36 GMT junnnninho 2016-04-22T06:19:36Z