title: Need to add a constant value in a column while loading a hive table
body: <p>I created a table named table1 in hive and i need to insert data from table2 into table1. I used the below statemnt to get the output. 
  Also i need to add a new column  with some constant value -- colx = 'colval' along with the columns in table2 but am not sure how to add it.. Thanks! </p>
  
  <p>INSERT INTO TABLE table1 select * FROM table2;</p>