title: Hive change column name without knowing column data type
body: <p>I want to change the column name of a Hive table without changing it's datatype.</p>
  
  <p>I tried below query but it requires datatype which I don't know.</p>
  
  <pre><code>ALTER TABLE test CHANGE a a1 INT;
  </code></pre>
  
  <p>I would like to prefix <code>SALES_</code> before all my columns irrespective of their column types.</p>
  
  <p><strong>Input Table</strong></p>
  
  <p><code>emp_id(int) emp_name(string) salary(double)</code></p>
  
  <p><strong>Output Table</strong></p>
  
  <p><code>sales_emp_id(int) sales_emp_name(string) sales_salary(double)</code></p>
  
  <p>Thanks in advance.</p>