title: Hive insert into table from select statement with different schemas
body: <p>For two tables in Hive:</p>
  
  <pre><code>Schema of Table A:
  id  name  age
  
  Schema of Table B:
  name
  
  # The type of "name" in Table A and B are both string
  </code></pre>
  
  <p>I want to select all rows from <code>Table B</code> and then append them to <code>Table A</code>, leaving the columns <code>id</code> and <code>age</code> null. </p>
  
  <p>The following statement would not work since the number of columns are not identical</p>
  
  <pre><code>insert into Table_A
  select * from Table_B
  ;
  </code></pre>
  
  <p>Is there any viable methods to append the data?</p>