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 im

Re: Simple data model for 1 simple range query?

2012-10-04 Thread T Akhayo
the other columns you can use 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:

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 date>Y and dat

Re: Two column families or One super column family?

2011-03-31 Thread T Akhayo
t you designing for performance instead of flexibility then everything gets a bit easier. Kind regards, T. Akhayo 2011/3/30 aaron morton > 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. > > There are

Two column families or One super column family?

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