title: Hive - facing challenge's in Dynamic partition error
body: <p>Can any one guide me where I am doing mistake while doing dynamic partition.</p>
  
  <p>--Staging table:</p>
  
  <pre><code>    create table staging_peopledata
      (
      firstname string, 
      secondname string, 
      salary float, 
      country string
      state string
      ) 
      row format delimited fields terminated by ',' lines terminated by '\n';
  </code></pre>
  
  <p>--Data for Staging table:</p>
  
  <pre><code>    John,David,30000,RUS,tnRUS
      John,David,30000,RUS,tnRUS
      Mary,David,5000,AUS,syAUS
      Mary,David,5000,AUS,syAUS
      Mary,David,5000,AUS,weAUS
      Pierre,Cathey,6000,RUS,kaRUS
      Pierre,Cathey,6000,RUS,kaRUS
      Ahmed,Talib,11000,US,bcUS
      Ahmed,Talib,11000,US,onUS
      Ahmed,Talib,11000,US,onUS
      kris,David,80000,UK,lnUK
      kris,David,80000,UK,soUK
  </code></pre>
  
  <p>--Production table:</p>
  
  <pre><code>    create table Production_peopledata
      (
      firstname string, 
      lastname string, 
      salary float) 
      partitioned by (country string, state string) 
      row format delimited fields terminated by ',' lines terminated by '\n';
  
      SET hive.exec.dynamic.partition=true;
      SET hive.exec.dynamic.partition.mode=nonstrict;
  
      insert overwrite table Production_peopledata 
      partition(country,state) 
      select firstname, secondname, salary, country, state from staging_peopledata;
  </code></pre>
  
  <p>If i execute the above command I am getting error as below.</p>
  
  <pre><code>    FAILED: SemanticException [Error 10096]: Dynamic partition strict mode
       requires atleast one static partition column. To turn this off set
       hive.exec.dynamic.partition.mode=nonstrict
  </code></pre>
  
  <p>Can any one tell me where I am doing the mistake.</p>