title: Adding a default value to a column while creating table in hive
body: <p>I'm able to create a hive table from data in external file. Now I wish to create another table from data in previous table with additional columns with default value.</p>
  
  <p>I understand that CREATE TABLE AS SELECT can be used but how do I add additional columns with default value?</p>