title: Hive Dynamic Partitioning, correct partitions are not created
body: <p>I'm trying to insert data in to a partitioned table, but not all the partitions were created (only null and zero values are created), please see below.</p>
  
  <p>hive> </p>
  
  <pre><code>select state_code,district_code,count(*) from marital_status group by state_code,district_code;
  Total MapReduce jobs = 1
  </code></pre>
  
  <p>MapReduce Jobs Launched: </p>
  
  <pre><code>...
  Job 0: Map: 1  Reduce: 1   Cumulative CPU: 3.49 sec   HDFS Read: 193305 HDFS Write: 240 SUCCESS
  Total MapReduce CPU Time Spent: 3 seconds 490 msec
  OK
  28  000 60
  28  532 60
  28  533 60
  28  534 60
  28  535 60
  28  536 60
  28  537 60
  28  538 60
  28  539 60
  28  540 60
  28  541 60
  28  542 60
  28  543 60
  28  544 60
  28  545 60
  28  546 60
  28  547 60
  28  548 60
  28  549 60
  28  550 60
  28  551 60
  28  552 60
  28  553 60
  28  554 60
  Time taken: 39.442 seconds, Fetched: 24 row(s)
  </code></pre>
  
  <p>I'm now inserting this table data to another table partitioned on district_code.</p>
  
  <p>hive> </p>
  
  <pre><code>insert overwrite table marital_status_part partition(DISTRICT_CODE) SELECT * FROM MARITAL_STATUS WHERE DISTRICT_CODE IN ('532','533','534');
  Total MapReduce jobs = 3
  Launching Job 1 out of 3
  </code></pre>
  
  <p>Number of reduce tasks is set to 0 since there's no reduce operator</p>
  
  <pre><code>Starting Job = job_201507071409_0020, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201507071409_0020
  Kill Command = /home/chaitanya/hadoop-1.2.1/libexec/../bin/hadoop job  -kill job_201507071409_0020
  </code></pre>
  
  <p>Hadoop job information for Stage-1: number of mappers: 1; number of reducers: </p>
  
  <pre><code>0
  2015-07-07 16:35:38,180 Stage-1 map = 0%,  reduce = 0%
  2015-07-07 16:35:48,214 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.01 sec
  2015-07-07 16:35:49,217 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.01 sec
  2015-07-07 16:35:50,220 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.01 sec
  2015-07-07 16:35:51,222 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.01 sec
  2015-07-07 16:35:52,226 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.01 sec
  2015-07-07 16:35:53,234 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.01 sec
  2015-07-07 16:35:54,237 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 2.01 sec
  MapReduce Total cumulative CPU time: 2 seconds 10 msec
  Ended Job = job_201507071409_0020
  Stage-4 is selected by condition resolver.
  Stage-3 is filtered out by condition resolver.
  Stage-5 is filtered out by condition resolver.
  Moving data to: hdfs://localhost:9000/tmp/hive-chaitanya/hive_2015-07-07_16-35-29_099_2560746659196071718-1/-ext-10000
  Loading data to table default.marital_status_part partition (district_code=null)
      Loading partition {district_code=0}
  Partition default.marital_status_part{district_code=0} stats: [num_files: 1, num_rows: 0, total_size: 22882, raw_data_size: 0]
  Table default.marital_status_part stats: [num_partitions: 1, num_files: 1, num_rows: 0, total_size: 22882, raw_data_size: 0]
  MapReduce Jobs Launched: 
  Job 0: Map: 1   Cumulative CPU: 2.01 sec   HDFS Read: 193305 HDFS Write: 22882 SUCCESS
  Total MapReduce CPU Time Spent: 2 seconds 10 msec
  OK
  Time taken: 26.254 seconds
  </code></pre>
  
  <p>what actually should happen is three folders has to be created with 532, 533, 534, but only 2 folders are created (NULL &amp; zero). Can you please help me on this ?</p>