title: how UPDATE rows in cassandra using only Partition Key?
body: <p>My table looks like this<br/></p>
  
  <pre><code>create table Notes(
      user_id varchar,
      real_time timestamp,
      insertion_time timeuuid,
      read boolean PRIMARY KEY (user_id,real_time,insertion_time)
  );
  
  create index read_index on Notes (read);
  </code></pre>
  
  <p>I want <strong>update all</strong> the <strong>rows</strong> with <strong>user_id</strong> = 'xxx' <strong>without</strong> having to specify all the clustering indexes.</p>
  
  <pre><code>UPDATE Notes SET read = true where user_id = 'xxx'; // Says Error
  </code></pre>
  
  <p>Error: message="Missing mandatory PRIMARY KEY part real_time</p>
  
  <p>I have tried creating a secondary index, but its not allowed on the primary key.</p>
  
  <p>How can i solve this?</p>
  
  <p>I chose user_id to be in the primary key cause i want to be able to do <code>select * from Notes where user_id = 'xxx'</code> should be possible.    </p>