title: How to remove table name in the column names in the query?
body: <p>I have a hive query that looks like this:</p>
  
  <pre><code>set hive.cli.print.header=true;
  select x1, x2, x3 from table1
  union all
  select x1, x2, x3 from table2
  </code></pre>
  
  <p>The problem is that, the hive automatically adds a new table name to the column names, so the column names in the result looks like this:</p>
  
  <pre><code>_u1.x1  _u1.x2  _u1.x3
  </code></pre>
  
  <p>I don't want the "_u1." How can I simply keep the column names as:</p>
  
  <pre><code>x1  x2  x3
  </code></pre>