title: Using multiple levels of partitions in Hive
body: <p>I am wondering if the following is possible.  I have data in Hive partitioned by date and logger, but I also have data that does not fall under a particular logger.</p>
  
  <p>e.g.</p>
  
  <pre><code>date=2012-01-01/logger=1/part000
  date=2012-01-01/logger=1/part001
  date=2012-01-01/logger=2/part000
  date=2012-01-01/logger=2/part001
  date=2012-01-01/part000
  </code></pre>
  
  <p>I created my table with:</p>
  
  <pre><code>create table mytable (
      ...
  )
  partitioned by (date string, logger int)
  ....
  ;
  </code></pre>
  
  <p>and added partitions:</p>
  
  <pre><code>alter table mytable add partition (date='2012-01-01', logger=1) location '/user/me/date=2012-01-01/logger=1/';
  ...
  </code></pre>
  
  <p>I can query data in the partitions, but I cannot query data in the file <code>date=2012-01-01/part000</code>.  Is it possible to include this file without it conforming to the partitioning?</p>
  
  <p>Thank you</p>