title: Insert into hive partitioned table SemanticException
body: <p>First I create a hive partitioned table:</p>
  
  <pre><code>hive&gt; create table partition_table
      &gt; (sid int ,sname string ,age int)            
      &gt; partitioned by (sex string)     
      &gt; row format delimited fields terminated by',';  
  OK
  Time taken: 1.232 seconds
  </code></pre>
  
  <p>The table desc is given below:</p>
  
  <pre><code> hive&gt; desc partition_table;
      OK
      sid                     int                                         
      sname                   string                                      
      age                     int                                         
      sex                     string                                      
  
  # Partition Information      
  # col_name              data_type               comment             
  
  sex                     string                                      
  Time taken: 0.34 seconds, Fetched: 9 row(s)
  </code></pre>
  
  <p>and then I insert some data into this table but it doesn't work.</p>
  
  <pre><code>hive&gt; insert into table partition_table partition(sex='M')select sno ,sname ,age from student1 where sex ='M';
  FAILED: SemanticException [Error 10006]: Line 1:44 Partition not found ''M''
  </code></pre>
  
  <p>To avoid this I wrote the following command and then executed my insert command, even then I get the same error repeatedly.</p>
  
  <pre><code>set exec.dynamic.partition=true;                                                                           
  set exec.dynamic.partition.mode=nonstrict;
  </code></pre>