title: Use Astyanax to list all rows in Cassandra column family
body: <p>I have some Cassandra related questions:</p>
  
  <p>I have to store some data (about 10M rows) (let's say a natural key - sortable, update timestamp, createDate (YYYYMMDD only) and a value field. I plan to create the following CF</p>
  
  <pre><code>CREATE TABLE data (
    id text,
    createdate text,
    updatedate timeuuid,
    value text,
    PRIMARY KEY (id, updatedate)
  );
  
  CREATE TABLE data_createdate (
    id text,
    createdate text,
    value text,
    PRIMARY KEY (id, createdate)
  );
  </code></pre>
  
  <p>My usage query will be like:</p>
  
  <ul>
  <li>get all rows (id, value, createdate, updatedate), so CQL like this will do
  <code>SELECT * FROM data</code></li>
  </ul>
  
  <p>I am using Astyanax, how do I do paging? Do I have to enable partitioner as order-preserved, so I can use <code>token(id)</code> in a range value to page through.</p>
  
  <ul>
  <li>get all rows with a updatedate range, so CQL like this will do
  <code>SELECT * FROM data where updatedate &gt; startdate and updatedate &lt; enddate</code></li>
  </ul>
  
  <p>Again, how do I do paging?</p>
  
  <ul>
  <li>get all rows with a createdate range, it's similar to the above question, but I can run CQL against <code>data_createdate</code> CF. Again, how do I do paging?</li>
  </ul>
  
  <p>Any suggest and comments? Thanks a lot.</p>