title: Combine Multiple Hive Tables as single table in Hadoop
body: <p>Hi I have multiple Hive tables around 15-20 tables. All the tables will be common schema . I Need to combine all the tables as single table.The single table should be queried from reporting tool, So performance is also needs to be care..</p>
  
  <p>I tried like this..</p>
  
  <pre><code>create table new as
  select * from table_a
  union all
  select * from table_b
  </code></pre>
  
  <p>Is there any other way to combine all the tables more efficient. Any help will be appreciated.</p>