ALLOW FILTERING usage

2014-03-17 Thread Kasper Middelboe Petersen
Hi, I have a table: CREATE TABLE json ( key text, group text, date timestamp, json text, PRIMARY KEY((key, group), date) ) WITH CLUSTERING ORDER BY (date DESC); This table will contain a small amount of data (only what an administrator creates by hand - a year

Re: Handling data consistency

2014-02-25 Thread Kasper Middelboe Petersen
can at least be updated later with the correct value. Not sure how much > help that is, but maybe it'll give you some ideas you can experiment with. > > Steve > > > On Mon, Feb 24, 2014 at 9:47 AM, Kasper Middelboe Petersen < > kas...@sybogames.com> wrote: > &g

Handling data consistency

2014-02-24 Thread Kasper Middelboe Petersen
Hi, My requirements include a system that can handle friend based highscore lists (as a user I have a bunch of friends from various social sites like Facebook). The user must have a highscore list that consist of his friends only. I have implemented this using the users ID as partition key and th

Re: TSocket read 0 bytes cqlsh error

2014-02-21 Thread Kasper Middelboe Petersen
Looks like the problem is caused by: https://issues.apache.org/jira/browse/CASSANDRA-5202 On Fri, Feb 21, 2014 at 10:26 AM, Kasper Middelboe Petersen < kas...@sybogames.com> wrote: > Hi, > > I'm getting a "TSocket read 0 bytes" error in cqlsh when doing a "SE

TSocket read 0 bytes cqlsh error

2014-02-21 Thread Kasper Middelboe Petersen
Hi, I'm getting a "TSocket read 0 bytes" error in cqlsh when doing a "SELECT * FROM tbl". Anyone else experienced this? It's a single node cluster running locally. I've tried doing a nodetool cleanup but that didn't solve the issue. Version information: INFO [main] 2014-02-21 10:20:25,224 Stor

Re: Datamodel for a highscore list

2014-01-24 Thread Kasper Middelboe Petersen
ying userid, and userscore. > > Is this a better explanation of my previous and lame explanation? > > Colin > +1 320 221 9531 > > > > On Thu, Jan 23, 2014 at 2:34 AM, Kasper Middelboe Petersen < > kas...@sybogames.com> wrote: > >> What would the consequen

Re: Datamodel for a highscore list

2014-01-23 Thread Kasper Middelboe Petersen
ption? On Wed, Jan 22, 2014 at 6:44 PM, Kasper Middelboe Petersen < kas...@sybogames.com> wrote: > Hi! > > I'm a little worried about the data model I have come up with for handling > highscores. > > I have a lot of users. Each user has a number of friends. I need

Re: Datamodel for a highscore list

2014-01-22 Thread Kasper Middelboe Petersen
mes? > > > -- > Colin > +1 320 221 9531 > > > > On Jan 22, 2014, at 10:59 AM, Kasper Middelboe Petersen < > kas...@sybogames.com> wrote: > > I can think of two cases where something bad would happen in this case: > 1. Something bad happens after the increme

Re: Datamodel for a highscore list

2014-01-22 Thread Kasper Middelboe Petersen
n-cassan...@unequivocal.co.uk> wrote: > On Wed, Jan 22, 2014 at 06:44:20PM +0100, Kasper Middelboe Petersen wrote: > >I'm a little worried about the data model I have come up with for > handling > >highscores. > >I have a lot of users. Each user has a number of fr

Re: Datamodel for a highscore list

2014-01-22 Thread Kasper Middelboe Petersen
with new > high score > > Would that work? > > -- > Colin > +1 320 221 9531 > > > > > On Jan 22, 2014, at 11:44 AM, Kasper Middelboe Petersen < > kas...@sybogames.com> wrote: > > > > Hi! > > > > I'm a little worried about the

Datamodel for a highscore list

2014-01-22 Thread Kasper Middelboe Petersen
Hi! I'm a little worried about the data model I have come up with for handling highscores. I have a lot of users. Each user has a number of friends. I need a highscore list pr friend list. I would like to have it optimized for reading the highscores as opposed to setting a new highscore as the u