title: how do I change the primary key value in Cassandra
body: <p>Thank you in advance for the help. I have 'status' column as primary key for the table and the status changes from submitted, reviewed, opened and closed. I can't remove the status as a primary key because I need to filter by the status. I am not using due-search or solr, is there any other solutions to my problem if not can someone please tell me how can solve this problem using Solr. </p>
  
  <pre><code>create table search_by_datetime_status  
  (   
      group_id    text,
      dateofstop  date,
      datetime    timestamp,
      starttime   time,
      status  text,
      createid    text,
      primary key ((group_id),datetime,status,createid)
  ) 
  with clustering order by (datetime desc);   
  </code></pre>
  
  <p>Query I need is like show me all the records with <code>group_id=? and datetime&gt;? and status=?</code> </p>