cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guillermo Winkler <gwink...@inconcertcc.com>
Subject What's the best modeling approach for ordering events by date?
Date Thu, 14 Apr 2011 16:25:28 GMT
I have a huge number of events I need to consume later, ordered by the date
the event occured.

My first approach to this problem was to use seconds since epoch as row key,
and event ids as column names (empty value), this way:

EventsByDate : {
    SecondsSinceEpoch: {
        evid:"", evid:"", evid:""
    }
}

And use OPP as partitioner. Using GetRangeSlices to retrieve ordered events
secuentially.

Now I have two problems to solve:

1) The system is realtime, so all the events in a given moment are hitting
the same box
2) Migrating from cassandra 0.6 to cassandra 0.7 OPP doesn't seem to like
LongType for row keys, was this purposedly deprecated?

I was thinking about secondary indexes, but it does not assure the order the
rows are coming out of cassandra.

Anyone has a better approach to model events by date given that
restrictions?

Thanks,
Guille



Mime
View raw message