title: Delete operation on a CQL3 table in Cassandra
body: <p>Say I have the following Column Family created using CQL3:</p>
  
  <pre><code>    CREATE TABLE users (
          id text,
          freq int,
          duration bigint,
          PRIMARY KEY (id, freq)
      )with clustering order by (freq desc);
  </code></pre>
  
  <p>I inserted some data in it e.g:  </p>
  
  <pre><code>    Row(id=u'key', freq=3, duration=1)
      Row(id=u'key', freq=4, duration=2)
      Row(id=u'key', freq=5, duration=4)
      Row(id=u'key', freq=6, duration=6)
  </code></pre>
  
  <p>Now i want to do an update operation. Precisely, i want to update the 'freq' value for a particular row given above. Since CQL3 won't allow me update a primary key part directly; I'd have to delete that entry first and then insert it again. But problem is that it wouldn't allow me perform delete operation using a non partition key column 'duration'. e.g it wont allow me perform this operation :</p>
  
  <pre><code>    Delete from users where id ='key' and duration =1;
  </code></pre>
  
  <p>Does any one know a work around this ? i would really appreciate this.  </p>