Hive insert into table from select statement with different schemas
<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>