Simple data model for 1 simple range query?

2012-10-03 Thread T Akhayo
Good evening, I have a quite simple data model. Pseudo CQL code: create table bars( timeframe int, date Date, info1 double, info2 double, .. primary key( timeframe, date ) ) My most important query is (which might be the only one actually): select * from bars where timeframe=X and dateY and

Re: Simple data model for 1 simple range query?

2012-10-04 Thread T Akhayo
the other operators. Also, if you ever find a need to partition the same data twice, you can always look into PlayOrm with multi-partitioning and it's Scalable SQL which can do joins when necessary. Later, Dean From: T Akhayo t.akh...@gmail.commailto:t.akh...@gmail.com Reply-To: user

Importing sstable with Composite key? (without is working)

2012-10-04 Thread T Akhayo
Good evening, Today i managed to get a small cluster running of 2 computers. I also managed to get my data model working and are able to import sstables created with SSTableSimpleUnsortedWriter with sstableloader. The only problem is when i try to use the composite key in my datamodel, after i

Two column families or One super column family?

2011-03-29 Thread T Akhayo
(with super column family). Kind regards, T. Akhayo

Re: Two column families or One super column family?

2011-03-31 Thread T Akhayo
designing for performance instead of flexibility then everything gets a bit easier. Kind regards, T. Akhayo 2011/3/30 aaron morton aa...@thelastpickle.com I would go with the solution that means you only have to make one request to serve your reads, so consider the super CF approach