Re: Organize model for range scans in Cassandra

2013-10-17 Thread Rajith Siriwardana
Hi Jon, Thanks for quick reply, I'm a newbie to Cassandra. Even though I made a mistake in previous mail. you got it right. I'll check what you've said. Cheers, Rajith. On Fri, Oct 18, 2013 at 11:47 AM, Jonathan Haddad wrote: > I'd avoid using super columns. I don't believe they're recommend

Re: Organize model for range scans in Cassandra

2013-10-17 Thread Jonathan Haddad
I'd avoid using super columns. I don't believe they're recommended anymore, and with CQL3 they aren't even supported (if you're interested in going that route). I think it's unlikely that you'll want a column family per company either. How many "ticker" entries do you plan on writing per company

Organize model for range scans in Cassandra

2013-10-17 Thread Rajith Siriwardana
Hi all, I have a problem like this, I have stock transaction data, as follows. Ticker data: Company name: timestamp: closing price (N): (V) trades (N) : (V) .. . .. In my model : I want to execute ra