title: query hive partitioned table over date/time range
body: <p>My hive table is partitioned on year, month, day, Hour</p>
  
  <p>Now I want to fetch data from 2014-05-27 to 2014-06-05
  How can I do that??</p>
  
  <p>I know one option is create partition on epoch(or yyyy-mm-dd-hh) and in query pass epoch time.
  Can I do it without loosing date hierarchy??</p>
  
  <p>Table Structure</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS table1 (col1 int, col2 int)
  PARTITIONED BY (year int, month int, day int, hour int) 
  STORED AS TEXTFILE;
  </code></pre>