title: cassandra Select on indexed columns and with IN clause for the PRIMARY KEY are not supported
body: <p>In Cassandra, I'm using the cql:</p>
  
  <pre><code>select msg from log where id in ('A', 'B') and filter1 = 'filter' 
  </code></pre>
  
  <p>(where <code>id</code> is the partition key and <code>filter1</code> is a secondary index and <code>filter1</code> cannot be used as a cluster column)</p>
  
  <p>This gives the response:</p>
  
  <pre><code>Select on indexed columns and with IN clause for the PRIMARY KEY are not supported
  </code></pre>
  
  <p>How can I change CQL to prevent this?</p>