Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=from
	:mime-version:content-type:subject:date:in-reply-to:to
	:references:message-id; q=dns; s=thelastpickle.com; b=qiDE+NKyZU
	+vJmJFQmlMNvBSYcxBStyG2X5Tv3/LlTdI8aLRJb54jwFq5nAi8/pRbA/2TBbO2t
	bUnvfQmtl/vqMZXgFWySgKxxEl4VQTN/Art+k3Kf9RBn2F4oGB6sdQKEhDMKN17r
	huVC2asBxfyKMgx5holfC5r4hX6/2Hx6k=
From: aaron morton <aaron@thelastpickle.com>
Mime-Version: 1.0 (Apple Message framework v1082)
Content-Type: multipart/alternative; boundary=Apple-Mail-2--550589084
Subject: Re: Data Model Question
Date: Fri, 3 Dec 2010 00:27:03 +1300
In-Reply-To: <AANLkTik9mc=QeX+jFtNFgSRUaMb5EHkBO07p=TMH7+3w@mail.gmail.com>
To: user@cassandra.apache.org
References: <AANLkTik9mc=QeX+jFtNFgSRUaMb5EHkBO07p=TMH7+3w@mail.gmail.com>
Message-Id: <7ED5F813-B417-4923-B3C0-9E5D0569FDC3@thelastpickle.com>


--Apple-Mail-2--550589084
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

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.=20

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.=20

Hope that helps.
Aaron


=20
On 2 Dec 2010, at 08:03, Pablo D. Salgado wrote:

> Hello,
>=20
> I need to store "products" data (product.name, product.price, =
product.state and product.owner) in Cassandra 0.7 rc1.=20
> The problem is that I need to get "products"  where product.price > XX =
AND product.price < XX AND product.name =3D XXX AND product.state =3D =
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?
>=20
> Thank you in advance,
>=20
> Pablo D. Salgado
> psalgado@colpix.net
> http://www.colpix.net
>=20


--Apple-Mail-2--550589084
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=us-ascii

<html><head></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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.&nbsp;<div><br></div><div>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.&nbsp;</div><div><br></div><div>Hope that =
helps.</div><div>Aaron</div><div><br></div><div><br></div><div>&nbsp;<br><=
div><div>On 2 Dec 2010, at 08:03, Pablo D. Salgado wrote:</div><br =
class=3D"Apple-interchange-newline"><blockquote =
type=3D"cite">Hello,<br><br>I need to store "products" data (<a =
href=3D"http://product.name/">product.name</a>, product.price, =
product.state and product.owner) in Cassandra 0.7 rc1. <br>The problem =
is that I need to get "products"&nbsp; where product.price &gt; XX AND =
product.price &lt; XX AND <a =
href=3D"http://product.name/">product.name</a> =3D XXX AND product.state =
=3D XXX. Also I need return the products with pagination sorted by one =
of their differents fields (<a =
href=3D"http://product.name/">product.name</a>, product.price, =
product.state or product.owner). This is a for an "advance product =
search" functionality.<br>
- 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)<br>
- 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.<br>Do you have any idea how to do the data model to =
reach this requirement?<br>
<br>Thank you in advance,<br><br>Pablo D. Salgado<br><a =
href=3D"mailto:psalgado@colpix.net">psalgado@colpix.net</a><br><a =
href=3D"http://www.colpix.net">http://www.colpix.net</a><br><br>
</blockquote></div><br></div></body></html>=

--Apple-Mail-2--550589084--