title: How to update clustering key in cassandra using update query?
body: <p>This is my table structure and I am updating the sequence with the following query:</p>
  
  <pre><code>Update styles set sequence=1 where styleid = 'CLASSIC';
  </code></pre>
  
  <p>I am getting error message as </p>
  
  <pre><code>PRIMARY KEY part sequence found in SET part
  Missing PRIMARY KEY part sequence
  
  CREATE TABLE styles (
    styleid ascii,
    sequence int,
    active boolean,
    image ascii,
    name ascii,
    PRIMARY KEY (styleid, sequence)
  ) WITH CLUSTERING ORDER BY (sequence DESC);
  </code></pre>
  
  <p>Please anyone help me to update the clustering key sequence so that it will be updated. Or any alternative method please share.</p>