Re: How can we use composite indexes and secondary indexes together

2012-06-01 Thread Vivek Mishra
Have a look at Kundera (https://github.com/impetus-opensource/Kundera). It does provide some sort of support (using Lucene) and allow you to deal with association in JPA way. -Vivek On Fri, Jun 1, 2012 at 6:54 AM, aaron morton wrote: > If you want to do arbitrary complex online / realtime querie

Re: How can we use composite indexes and secondary indexes together

2012-05-31 Thread aaron morton
If you want to do arbitrary complex online / realtime queries look at Data Stax Enterprise, or https://github.com/tjake/Solandra or straight Solr. Alternatively denormalise the model to materialise the results when you insert so you query is a straight lookup. Or do some client side filtering /

How can we use composite indexes and secondary indexes together

2012-05-31 Thread Nury Redjepow
We want to use cassandra to store complex data. But we can't figure out, how to organize indexes. Our table (column family) looks like this: Users = { RandomId int, Firstname varchar, Lastname varchar, Age int, Country int, ChildCount int } In our queries we have mandatory fields (Firstname,Lastn