title: Can you change the partition key of a particular row in a Cassandra table?
body: <p>I am unsure if you can change the partition key value of a particular row in a table. For example, if you had a table such that the PRIMARY KEY(name, title) and have some entry where name = &quot;John&quot;, title = &quot;New&quot;. Would we be able to run:</p>
  <pre><code>UPDATE table
  SET name=&quot;Ron&quot;
  WHERE name=&quot;John&quot; AND title=&quot;New&quot;;
  </code></pre>
  <p>I understand the general concept of the partition key such that it uniquely identifies rows in a partition while also identifying what nodes hold said partitions. So this leads to me to believe this would not run.</p>