title: Apache Cassandra table not sorting by name or title correctly
body: <p>I have the following Apache Cassandra Table working.</p>
  
  <pre><code>CREATE TABLE user_songs (
      member_id int,
      song_id int,
      title text,
      timestamp timeuuid,
      album_id int,
      album_title text,
      artist_names set&lt;text&gt;,
      PRIMARY KEY ((member_id, song_id), title)
  ) WITH CLUSTERING ORDER BY (title ASC)
  CREATE INDEX user_songs_member_id_idx ON music.user_songs (member_id);
  </code></pre>
  
  <p>When I try to do a <code>select * FROM user_songs WHERE member_id = 1;</code> I thought the Clustering Order by title would have given me a sorted ASC of the return - but it doesn't</p>
  
  <p>Two questions:</p>
  
  <ul>
  <li>Is there something with the table in terms of ordering or PK?</li>
  <li>Do I need more tables for my needs in order to have a sorted title by member_id.</li>
  </ul>
  
  <p>Note - my Cassandra queries for this table are:</p>
  
  <ul>
  <li>Find all songs with member_id</li>
  <li>Remove a song from memeber_id given song_id</li>
  </ul>
  
  <p>Hence why the PK is composite</p>
  
  <p><strong>UPDATE</strong>
  It is simialr to: <a href="https://stackoverflow.com/questions/26853410/query-results-not-ordered-despite-with-clustering-order-by">Query results not ordered despite WITH CLUSTERING ORDER BY</a></p>
  
  <p>However one of the suggestion in the comments is to put <code>member_id,song_id,title</code> as primary instead of the composite that I currently have. When I do that It seems that I cannot delete with only song_id and member_id which is the data that I get for deleting (hence title is missing when deleting)</p>