title: Cassandra - get interval contains given timestamp
body: <p>I have table in Cassandra:</p>
  
  <pre><code>CREATE TABLE test (
   bucket int,  
   start timestamp,
   end timestamp,  
   PRIMARY KEY((bucket),start, end)
  );
  </code></pre>
  
  <p>And I would like to get a query like that:</p>
  
  <pre><code>SELECT * FROM test where bucket = 1 and start &lt;= current_time and end &gt;= current_time
  </code></pre>
  
  <p>In another word, I would like to find interval which contains given timestamp.</p>
  
  <p>I know that query is wrong. I tried to do it also with Multi-column slice restrictions, but it's also useless in this case. Is there some way to do this?</p>