Re: Data Modeling: Comments with Voting

2012-10-01 Thread aaron morton
than 1 comment can have the same votes) Regards, Roshni Date: Wed, 26 Sep 2012 17:36:13 -0700 From: k...@mustardgrain.com To: user@cassandra.apache.org CC: d...@venarc.com Subject: Re: Data Modeling: Comments with Voting Depending on your needs, you could simply duplicate

RE: Data Modeling: Comments with Voting

2012-10-01 Thread Roshni Rajagopal
. From: aa...@thelastpickle.com Subject: Re: Data Modeling: Comments with Voting Date: Tue, 2 Oct 2012 10:39:42 +1300 To: user@cassandra.apache.org You cannot (and probably do not want to) sort continually when the voting is going on. You can store the votes using CounterColumnTypes in column values

Re: Data Modeling: Comments with Voting

2012-09-29 Thread Drew Kutcharian
Date: Wed, 26 Sep 2012 17:36:13 -0700 From: k...@mustardgrain.com To: user@cassandra.apache.org CC: d...@venarc.com Subject: Re: Data Modeling: Comments with Voting Depending on your needs, you could simply duplicate the comments in two separate CFs with the column names including

RE: Data Modeling: Comments with Voting

2012-09-27 Thread Roshni Rajagopal
: Re: Data Modeling: Comments with Voting Depending on your needs, you could simply duplicate the comments in two separate CFs with the column names including time in one and the vote in the other. If you allow for updates to the comments, that would pose some issues you'd need to solve

Data Modeling: Comments with Voting

2012-09-26 Thread Drew Kutcharian
Hi Guys, Wondering what would be the best way to model a flat (no sub comments, i.e. twitter) comments list with support for voting (where I can sort by create time or votes) in Cassandra? To demonstrate: Sorted by create time: - comment 1 (5 votes) - comment 2 (1 votes) - comment 3 (no

Re: Data Modeling: Comments with Voting

2012-09-26 Thread Kirk True
Depending on your needs, you could simply duplicate the comments in two separate CFs with the column names including time in one and the vote in the other. If you allow for updates to the comments, that would pose some issues you'd need to solve at the app level. On 9/26/12 4:28 PM, Drew