title: Pattern matching 'like' on primary key in cassandra
body: <p>In Cassandra <strong>'like'</strong> can be used to find matching results satisfying the search pattern on SASI indexed columns, it is working perfectly well, but how to use like on primary keys. </p>
  
  <p>this is my table:</p>
  
  <pre><code>CREATE TABLE indexxx (
      title VARCHAR,
      PRIMARY KEY (title));
  </code></pre>
  
  <p><strong>Indexing is not allowed on primary keys</strong>,</p>
  
  <pre><code>CREATE CUSTOM INDEX testtt ON indexxx (title) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode': 'CONTAINS', 'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.StandardAnalyzer', 'case_sensitive': 'false'};
  
  
  
  InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot create secondary index on partition key column title"
  </code></pre>
  
  <p>when tried to use like without sasi indexing,</p>
  
  <pre><code>select * from indexxx  where title like '%kkk%' ;
  
  InvalidRequest: Error from server: code=2200 [Invalid query] message="LIKE restriction is only supported on properly indexed columns. title LIKE '%kkk%' is not valid." 
  </code></pre>