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.
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 / aggregation.If you want to do the queries offline, you can use Pig or Hive with Hadoop over Cassandra. The Apache Cassandra distro includes the pig support, hive is coming (i think) and there are Hadoop interfaces. You can also look at Data Stax Enterprise.CheersOn 31/05/2012, at 11:07 PM, Nury Redjepow wrote:The main point is, how can we join data in cassandra. If I make few index column families, I need to intersect the values, to get rows that pass all search criteria??? Or should I use something based on Hadoop (Pig,Hive) to make such queries?