title: How to achieve a similar result as OUTER UNION CORR in Hive SQL?
body: <p>I am trying to create a table by combining multiple tables, but I need to get all columns on my output table. </p>
  
  <pre class="lang-sql prettyprint-override"><code>Create table output_table
  Select cl1, cl2, cl3, cl4
  From table1
  Union all
  Select cl1, cl2, cl3, cl5
  From table2
  Union all
  Select cl1, cl2, cl3, cl6
  From table3
  Union all
  Select cl1, cl2, cl3, cl7
  From table4 
  </code></pre>
  
  <p>On this case, my output table should have contained all columns.</p>
  
  <p>Is there any way to get this, please </p>