Implementing queue in Cassandra

2012-01-18 Thread Eric Martell
Hi,   I am having 10 millions of rows with in sql db in key table. key_id - key_value For each request I am fetching  one key_id and removing that from the key table. Each request should get unique key_id. Similar to java queue but keys persists in DB. How do I implement that in Cassandra

Re: Implementing queue in Cassandra

2012-01-18 Thread Tatu Saloranta
On Wed, Jan 18, 2012 at 7:31 AM, Eric Martell workoutexc...@yahoo.com wrote: Hi,   I am having 10 millions of rows with in sql db in key table. key_id - key_value For each request I am fetching  one key_id and removing that from the key table. Each request should get unique key_id.

Re: Implementing queue in Cassandra

2012-01-18 Thread Todd Burruss
if you need a strictly FIFO queue, what I'm about to offer does not satisfy FIFO. I created a mostly FIFO queue for processing work items that could arrive out of order, didn't matter for my use case. https://github.com/btoddb/cassandra-queue/wiki/Queue-Design maintaining FIFO order using

Re: Implementing queue in Cassandra

2012-01-18 Thread Norman Maurer
Why not just use something which fits better for the job then cassandra. Did you checkout kafka and kestrel ? Bye, Norman Ps: I think you should better ask these questions on user@ 2012/1/19 Todd Burruss bburr...@expedia.com: if you need a strictly FIFO queue, what I'm about to offer does not