title: cassandra get all records in time range
body: <p>I have to work with a column family that has (user_id, timestamp) as key. In my query I would like to fetch all records in a given time range independent of the user_id. This is the exact table schema:</p>
  
  <pre><code>CREATE TABLE userlog (
    user_id text,
    ts timestamp,
    action text,
    app_type text,
    channel_name text,
    channel_session_id text,
    pid text,
    region_id text,
    PRIMARY KEY (user_id, ts)
  )
  </code></pre>
  
  <p>I tried to run</p>
  
  <pre><code>SELECT * FROM userlog  WHERE ts &gt;= '2013-01-01 00:00:00+0200' AND  ts &lt;= '2013-08-13 23:59:00+0200' ALLOW FILTERING;
  </code></pre>
  
  <p>which works fine on my local cassandra installation containing a small data set but fails with</p>
  
  <pre><code>Request did not complete within rpc_timeout.
  </code></pre>
  
  <p>on the productive system containing all the data.</p>
  
  <p>Is there a, preferably cql, query that runs smoothly with the given column family or de we have to change the design?</p>