Hi I have a requirement of versioning to be done in Cassandra.
Following is my column family definition *create table file_details(id text primary key, fname text, version int, mimetype text);* I have a secondary index created on fname column. Whenever I do an insert for the same 'fname', the version should be incremented. And when I retrieve a row with fname it should return me the latest version row. Is there a better way to do in Cassandra? Please suggest what approach needs to be taken. Regards, Dawood