cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vivek Mishra <mishra.v...@gmail.com>
Subject Re: How can we use composite indexes and secondary indexes together
Date Fri, 01 Jun 2012 11:20:26 GMT
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 <aaron@thelastpickle.com>wrote:

> 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.
>
>
> Cheers
>
> -----------------
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 31/05/2012, at 11:07 PM, Nury Redjepow wrote:
>
> 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,Lastname,Age) and extra
> search options (Country,ChildCount). How do we organize index to make this
> kind of queries fast?
>
> First I thought, it would be natural to make composite index on
> (Firstname,Lastname,Age) and add separate secondary index on remaining
> fields (Country and ChildCount). But I can't insert rows into table after
> creating secondary indexes. And also, I can't query the table.
>
> I'm using cassandra 1.1.0, and cqlsh with --cql3 option.
>
> Any other suggestions to solve our problem (complex queries with mandatory
> and additional options) are welcome.
> 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?
>
> Respectfully, Nury
>
> ------------------------------
>
> ------------------------------
>
> ------------------------------
>
> ------------------------------
>
>
>

Mime
View raw message