title: Time series modelling( with start & end date) in cassandra
body: <p>I am doing time series data modelling where I have a start date and end date of events. I need to query on that data model like the following:</p>
  
  <pre><code>Select * from tablename where startdate&gt;'2012-08-09' and enddate&lt;'2012-09-09'
  </code></pre>
  
  <p>I referred to the following link on <a href="http://www.datastax.com/dev/blog/a-deep-look-to-the-cql-where-clause" rel="nofollow">cql where clause</a> but I couldn't achieve this. Any way to do that? I can also change the data model or any cql tweaks. I am using Cassandra 2.1.</p>