title: Cassandra cql select sorting
body: <p>If I define a table like this using cql:</p>
  
  <pre><code>CREATE TABLE scores (
   name text,
   age int,
   score int,
   date timestamp,
   PRIMARY KEY (name, age, score)
  );
  </code></pre>
  
  <p>And do a SELECT in cqlsh like this:</p>
  
  <pre><code>select * from mykeyspace.scores;
  </code></pre>
  
  <p>The result displayed seems to always be sorted by 'age', then 'score' automatically in ascending order regardless of input-data ordering (as expected, return rows are not sorted by the partition key 'name').  I have the following questions:</p>
  
  <ol>
  <li>Does <code>SELECT</code> automatically sort return rows by the clustering keys?</li>
  <li>If <strong>yes</strong>, what's the purpose of using the <code>ORDER BY</code> clause when using <code>SELECT</code>?</li>
  <li>If <strong>no</strong>, how do I get the return rows to sort by the clustering keys since cql doesn't allow <code>ORDER BY</code> on a <code>select *</code>?</li>
  </ol>