title: Multiple parts created while inserting in Hive table
body: <p>I have a hive table (with compression) with definition like </p>
  
  <pre><code>create table temp1 (col1 string, col2 int)
  partitioned by (col3 string, col4 string) 
  row format delimited 
  fields terminated by ',' 
  escaped by '\\' 
  lines terminated by '\n'
  stored as sequencefile;
  </code></pre>
  
  <p>When I do a simple select and insert (no reducers running) from another hive table to this table i see a unique pattern, data in this table with compression gets split in high no of files of very small size (<strong>table 1</strong> : at times 1gb data gets split over 200-300 files thus increasing the no of blocks consumed though it should have spanned only 16blocks) due to this very high no of maps are formed when I query this new table. File size does not go beyond 245mb (<strong>table 2</strong>). Is there a setting to restrict this to 64mb (or multiple of 64mb or just a single file) as my block size is 64 mb and hence excess blocks will not get created.</p>
  
  <p><strong>TABLE 1</strong></p>
  
  <p><strong>Name      |    Type       |    Size       |    Block Size</strong></p>
  
  <p>000000_0        |    file       |    30.22MB        |    64 MB</p>
  
  <p>000001_0        |    file       |    26.19MB        |    64 MB</p>
  
  <p>000002_0        |    file       |    25.19MB        |    64 MB</p>
  
  <p>000003_0        |    file       |    24.74MB        |    64 MB</p>
  
  <p>000004_0        |    file       |    24.54MB        |    64 MB</p>
  
  <p>..........</p>
  
  <p>000031_0        |    file       |    0.9MB      |    64 MB</p>
  
  <p><strong>TABLE 2</strong></p>
  
  <p><strong>Name      |    Type       |    Size       |    Block Size</strong></p>
  
  <p>000000_0        |    file       |    245.02MB       |    64 MB</p>
  
  <p>000001_0        |    file       |    245.01MB       |    64 MB</p>
  
  <p>000002_0        |    file       |    244.53MB       |    64 MB</p>
  
  <p>000003_0        |    file       |    244.4MB        |    64 MB</p>
  
  <p>000004_0        |    file       |    198.21MB       |    64 MB</p>