title: Alter the schema of Hive table
body: <p>I want to alter the table created in Hive which is mapped to HBase fields. Recently i have included few more column into HBase and thus would lik to add those fields into Hive as well.</p>
  
  <p>for creation i used: </p>
  
  <pre><code> CREATE EXTERNAL TABLE test1(rowKey STRING,a STRING,b STRING) 
   STORED BY  'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES 
   ('hbase.columns.mapping' = ':key,cf:address,cf:name') 
   TBLPROPERTIES ('hbase.table.name' = 'test');
  </code></pre>
  
  <p>now i want to add one more column in hive tables test1 which should be mapped to hbase but i don't find any way to do this. Pleas help Thanks.</p>