You don't, they are not preserved, as discussed in another, almost identical thread in the past 2 days. If you want to retain history, you must do so your self, usually by maintaining indices.
On Sun, Aug 8, 2010 at 1:29 PM, Kevin Cox <kevin....@wscon.com> wrote: > Taking from the CassandaraCLI example page for simplicity, one enters the > following into the > > cassandra> set Keyspace1.Standard2['jsmith']['age'] = '42' > > cassandra> get Keyspace1.Standard2['jsmith'] > => (column=last, value=Smith, timestamp=1279780450578000) > => (column=first, value=John, timestamp=1279780434745000) > => (column=age, value=42, timestamp=1279780457458000) > Returned 3 results. > > cassandra> set Keyspace1.Standard2['jsmith']['age'] = '43' > Value inserted. > > cassandra> set Keyspace1.Standard2['jsmith']['age'] = '44' > Value inserted. > > cassandra> get Keyspace1.Standard2['jsmith'] ['age'] > => (column=age, value=44, timestamp=1281297196787000) <<< 44 is the current > value > > How could I get access to the previous values of the age column? (like values > 42 and 43 and their timestamps that were entered prior to value 44) > Are previous values kept or replaced in Cassandra? > Is there any way to preserve and/or access column history? > > Thanks. >