title: Only date range scanning Cassandra CQL timestamp
body: <p>I have a table like given below.</p>
  
  <pre><code>CREATE TEST(
   HOURLYTIME TIMESTAMP,
   FULLTIME TIMESTAMP,
   DATA TEXT,
   PRIMARY KEY(HOURLYTIME,FULLTIME)
  )
  </code></pre>
  
  <p>I inserted the record <code>(2014-12-12 00:00:00,2014-12-12 00:00:01,'Hello World')</code></p>
  
  <p>I would like to search based on date time range in HOURLYTIME field which holds hourly records.When i tried with token() like</p>
  
  <p><code>select * from TEST where token(HOURLYTIME)=token('2014-12-12')</code> </p>
  
  <p>to get all the records for that date it returns only for one hour record i.e for</p>
  
  <pre><code> 2014-12-12 **00:00:00**
  </code></pre>
  
  <p>If i add date range </p>
  
  <pre><code>select * from TEST where token(HOURLYTIME)&gt;=token('2014-12-12') AND token(HOURLYTIME)&lt;=token('2014-12-14');
  </code></pre>
  
  <p>It gives the error : <em>More than one restriction was found for the start bound</em>. </p>
  
  <p>How to resolve this issue.</p>
  
  <p>I am able to scan using FULLTIME but i need to provide ALLOW FILTERING which will scan whole records &amp; inefficient.</p>