title: Query columns based on datetime in Cassandra
body: <p>We are trying to create/query information from a CF based on the following structure (e.g. a datetime, datetime, integer)</p>
  
  <pre><code>e.g.
  03-22-2012 10.00, 03-22-2012 10.30 100
  03-22-2012 10.30, 03-22-2012 11.00 50
  03-22-2012 11.00, 03-22-2012 11.30 200
  </code></pre>
  
  <p>How do I model the above structure in Cassandra and perform the following queries via Hector.</p>
  
  <pre><code>select * from &lt;CF&gt; where datetime1 &gt; 03-22-2012 10.00 and datetime2 &lt; 03-22-2012 10.30
  select * from &lt;CF&gt; where datetime1 &gt; 03-22-2012 10.00 and datetime2 &lt; 03-22-2012 11.00
  select * from &lt;CF&gt; where datetime = 03-22-2012 (i.e. for the entire day)
  </code></pre>