title: Cassandra - delete all rows stored in a primary key value fast?
body: <p>I am creating a table which will contain a lot (we are talking million if not billion) of data stored by a primary key which will be a year stored as int.
  We are doing this because we wish to be able to execute simple purge.</p>
  
  <p>table look like this:</p>
  
  <pre><code>TABLE data (
   year int,
   fulldate date,
   ref1 text,
   ref2 text,
   data blob,
   PRIMARY KEY ((year), fulldate, ref1, ref2)
  );
  </code></pre>
  
  <p>In the future, we plan to drop all the data of a year and will not add any more data to this particular year.</p>
  
  <p>Can we delete all the data stored by a primary key value in an efficient way? Like doing something similar to a drop?</p>
  
  <p>I haven't seen anything about such a thing in the doc, but I am new to Cassandra so maybe there is an internal optimization done or something?</p>
  
  <p>Thanks for the help.</p>