title: Cassandra error - Order By only supported when partition key is restricted by EQ or IN
body: <p>Here is the table I'm creating, this table contains information about players that played the last mundial cup.</p>
  
  <pre><code>CREATE TABLE players ( 
        group text, equipt text, number int, position text, name text,
        day int, month int, year int, 
        club text, liga text, capitan text,
  PRIMARY key (name, day, month, year));
  </code></pre>
  
  <p>When doing the following query :  </p>
  
  <blockquote>
    <p><strong>Obtain 5 names from the oldest players that were captain of the selection team</strong></p>
  </blockquote>
  
  <p>Here is my query:  </p>
  
  <pre><code>SELECT name FROM players WHERE captain='YES' ORDER BY year DESC LIMIT 5;
  </code></pre>
  
  <p>And I am getting this error:</p>
  
  <blockquote>
    <p><strong>Order By only supported when partition key is restricted by EQ or IN</strong></p>
  </blockquote>
  
  <p>I think is a problem about the table I'm creating, but I don't know how to solve it.</p>
  
  <p>Thanks.</p>