title: Cassandra CQL select '!=' operator
body: <p>I know that <code>!=</code> is not supported in CQL select statements. And, I also know that <code>!=</code> queries are not efficient. But why is it not allowed even if I am prepared to accept filtering? </p>
  
  <p>For example, I want something like this: <code>Select * from foo where PK='something' and CK1='something' and CK2!='something' allow filtering</code></p>
  
  <p>My reasoning is that the cardinality would be low enough after <code>PK</code> and <code>CK1</code> that I don't care if Cassandra has to read all the remaining rows. </p>
  
  <p>Question: apart from doing application side filter, is there any way to do that using CQL only?</p>