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.
On 2 Dec 2010, at 08:03, Pablo D. Salgado wrote:
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