On Wed, Dec 22, 2010 at 4:54 AM, Prasad Sunkari <email@example.com>
I have a column family for users of my system and I need to have tags set to these users. My current plan is to have a column that holds a string (comma separated tags).
I am not clear if this the best way to do it. Specially because this may lead to a complications when more than one administrator is trying to tag the same user (lost updates) as well as the secondary indexes (if I wanted to use the built in secondary indexes). I also am not sure if it is possible to have a secondary index on a multi-valued column!
Another alternative is to have it in a super column with each tag being a column by itself and let my application take care of the secondary indexes.
I am currently of the opinion that the second solution is the only thing that I could do.
Any suggestions? Since this is my first app on Cassandra I am trying to see if my opinion is correct.