title: Cassandra time range query
body: <p>Before you downvote I would like to state that I looked at all of the similar questions but I am still getting the dreaded "PRIMARY KEY column cannot be restricted" error.</p>
  
  <p>Here's my table structure:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS events (
      id text,
      name text,
      start_time timestamp,
      end_time timestamp,
      parameters blob,
      PRIMARY KEY (id, name, start_time, end_time)
  );
  </code></pre>
  
  <p>And here's the query I am trying to execute:</p>
  
  <pre><code>SELECT * FROM events WHERE name = ? AND start_time &gt;= ? AND end_time &lt;= ?;
  </code></pre>
  
  <p>I am really stuck at this. Can anyone tell me what I am doing wrong?</p>
  
  <p>Thanks,
  Deniz</p>