title: cassandra select by clustering key
body: <p>I have a problem with cassandra ( ScyllaDB ( indexes not supported ! ) )</p>
  
  <p>in my scenario i have a table with three columns</p>
  
  <p><code>CREATE TABLE test (a text , b text , c text , PRIMARY KEY ( a , b ,c ) );</code></p>
  
  <p>Now i want to select data's by the second cluster key ( c )
  but b is needed.</p>
  
  <p>My goal but incorrect query is : </p>
  
  <p><code>SELECT * FROM test WHERE c='...' ALLOW FILTERING</code> </p>
  
  <p>And correct query is this :</p>
  
  <p><code>SELECT * FROM test WHERE b='...' AND c='...' ALLOW FILTERING</code></p>
  
  <p>is there any solution for my problem to only use b cluster key in select query ? </p>