title: Inserting into Hive table - Non Partitioned table to Partitioned table - Cannot insert into target table because column number/types
body: <p><strong>When I tried to insert into a Partiotioned table I am getting the bellow error 
  SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column number/types are different ''US'': Table insclause-0 has 2 columns, but query has 3 columns.</strong></p>
  
  <p><strong>My Input data</strong> </p>
  
  <pre><code>1,aaa,US
  2,bbb,US
  3,ccc,IN
  4,ddd,US
  5,eee,IN
  6,fff,IN
  7,ggg,US
  </code></pre>
  
  <p><strong>Created hive table tx</strong> </p>
  
  <pre><code>create table tx (no int,name string,country string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
  </code></pre>
  
  <p><em>Created Partitioned table t1 <strong>partitioned by country</em></strong></p>
  
  <pre><code>create table t1 (no int,name string) PARTITIONED BY (country string)  ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
  </code></pre>
  
  <p><strong><em>I tried the bellow two insert, but failed</em></strong></p>
  
  <pre><code>    INSERT OVERWRITE TABLE t1 PARTITION (country='US') 
  SELECT *   from tx where country = 'US';
  
      INSERT OVERWRITE TABLE t1 PARTITION (country='US') 
  SELECT no,name,country from tx where country = 'US';
  </code></pre>
  
  <p><strong>Error</strong> <em>: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column number/types are different ''US'': Table insclause-0 has 2 columns, but query has 3 columns.</em></p>