I would try:
Comments CF:
row_key: (thing_type : thing_id ) where thing_type is "city" etc
column_name: (comment_id (reversed)) where comment_id is a timeuuid
column_value: the comment.
You will need to be wary of very wide rows.
It's a pretty simple model for CQL 3 as well:
CREATE TABLE comm
Hi all, in my very old Cassandra schema (started with 0.6 -- so without
secondary indexes -- and now on 1.0.6) I have a rating&review platform with
about 1 million review. The core of the application is the review that a user
can leave about a company. At the time I created many CF: Comments,
U