title: partition the hive data complex data types while inserting data its shows error
body: <p>i created a table using hive i want to partition the data  based on location</p>
  
  <pre><code>create table student(
        id bigint
       ,name string
       ,location string
       , course array&lt;string&gt;)
  ROW FORMAT DELIMiTED fields terminated by '\t'
  collection items terminated by ','
  stored as textfile;
  </code></pre>
  
  <p>and data like</p>
  
  <pre><code>100 student1    ongole  java,.net,hadoop
  101 student2    hyderabad   .net,hadoop
  102 student3    vizag   java,hadoop
  103 student4    ongole  .net,hadoop
  104 student5    vizag   java,.net
  105 student6    ongole  java,.net,hadoop
  106 student7    neollre .net,hadoop
  </code></pre>
  
  <p>creating partition table:</p>
  
  <pre><code>create table student_partition(
        id bigint
       ,name string
       ,course array&lt;string&gt;)
  PARTITIONED BY (address string)
  ROW FORMAT DELIMiTED fields terminated by '\t'
  collection items terminated by ','
  stored as textfile;
  </code></pre>
  
  <blockquote>
    <p>INSERT OVERWRITE TABLE student_partition PARTITION(address) select *
    from student;</p>
  </blockquote>
  
  <p>i'm trying to partition the data based on location but it shows below error:</p>
  
  <blockquote>
    <p>FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into
    target table because column number/types are different 'address':
    Cannot convert column 2 from string to array.</p>
  </blockquote>
  
  <p>please anyone help me.</p>