select older versions of data after update in Cassandra
<p>This is my use-case. </p>

<p>I have inserted a row of data in Cassandra with the following query: </p>

<pre><code>INSERT INTO TableWide1 (UID, TimeStampCol, Value, DateCol) VALUES ('id1','2016-03-24 17:54:36',45,'2015-03-24 00:00:00');
</code></pre>

<p>I update one row to have a new value. </p>

<pre><code>update TableWide1 set Value = 46 where uid = 'id1' and datecol='2015-03-24 00:00:00' and timestampcol='2016-03-24 17:54:36';
</code></pre>

<p>Now, I would like to see all versions of this data from Cassandra. I know in HBase, this is pretty straightforward, but in Cassandra, is this even possible? </p>

<p>I explored a bit using writetime(), but it just gives the latest time of the newly updated data. And this cannot be used in where clause too.  </p>

<p>This is how my schema looks like: </p>

<pre><code>CREATE TABLE TableWide1(
  UID varchar,
  TimeStampCol timestamp,
  Value double,
  DateCol timestamp,
  PRIMARY KEY ((UID,DateCol), TimeStampCol)
);
</code></pre>

<p>So is this technically possible, given the fact the old data still exists in Cassandra? </p>