cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jake Luciani <jak...@gmail.com>
Subject Re: Data Model Question
Date Thu, 02 Dec 2010 14:33:00 GMT
You can also run Solr with Cassandra as the backend:

https://github.com/tjake/Lucandra/tree/solandra

</shameless_plug>

-Jake

On Thu, Dec 2, 2010 at 6:27 AM, aaron morton <aaron@thelastpickle.com>wrote:

> Have you considered using Solr / lucene for the search? It has a lot more
> search features, and it really good at faceted navigation through a product
> catalogue. It sounds like it would be a better fit for this task.
>
> You can build facets for your price ranges, do the product name thing and
> filter by some sort product state. Sort it any way you want and paginate
> it.
>
> Hope that helps.
> Aaron
>
>
>
> On 2 Dec 2010, at 08:03, Pablo D. Salgado wrote:
>
> Hello,
>
> I need to store "products" data (product.name, product.price,
> product.state and product.owner) in Cassandra 0.7 rc1.
> The problem is that I need to get "products"  where product.price > XX AND
> product.price < XX AND product.name = XXX AND product.state = XXX. Also I
> need return the products with pagination sorted by one of their differents
> fields (product.name, product.price, product.state or product.owner). This
> is a for an "advance product search" functionality.
> - I know that I can do the WHERE clause with secondary index of Cassandra
> 0.7 but I can't make the pagination because I don't know how to implement
> the "previuos" functionality for Row Pagination. (I can use OPP if needed)
> - Also I know how to do pagination on columns but I can't do the WHERE
> clause with more than two fields because the result may be not sorted by the
> correct field.
> Do you have any idea how to do the data model to reach this requirement?
>
> Thank you in advance,
>
> Pablo D. Salgado
> psalgado@colpix.net
> http://www.colpix.net
>
>
>

Mime
View raw message