title: alter composite primary key in cassandra CQL 3.0
body: <p>I'm in a situation where I need to change the the composite primary key as follows:</p>
  
  <p><strong>Old Primary Key: (id, source, attribute_name, updated_at);</strong></p>
  
  <p><strong>New Primary Key I want: (source, id, attribute_name, updated_at);</strong></p>
  
  <p>I issued the following (mysql like) command:</p>
  
  <pre><code>ALTER TABLE general_trend_table 
  DROP PRIMARY KEY, 
  ADD PRIMARY KEY(source, id, attribute_name, updated_at);
  </code></pre>
  
  <p>I got the following error:</p>
  
  <p><strong>Bad Request: line 1:38 no viable alternative at input 'PRIMARY'</strong></p>
  
  <p>any idea how to get around this problem? more specifically I want to know is there any way to change the primary key in cassandra?</p>