Re: Refactoring old project

2013-10-01 Thread Aaron Morton
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

Refactoring old project

2013-09-27 Thread cbert...@libero.it
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