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=to:from
	:subject:message-id:content-type:mime-version:in-reply-to:date;
	 q=dns; s=thelastpickle.com; b=PFhIVqVHTEpl3sunlqE02AzKC3LSQavcv
	/m2/EF3CjUV/aacLfyPtaiZovu7x3FZY/si2gnTK754KbqKdWxPhMKu/wqriZsnx
	mjs+pj5Z61l3wSsl/6uMn43/IG31OjYIr/CIXAZ7JL2tT97VH2a1ISbznCw6f9m1
	syhueQnyls=
To: user@cassandra.apache.org
From: Aaron Morton <aaron@thelastpickle.com>
Subject: Re: Can we filter a key or a column name using regular expression?
Message-id: <fa15cc86-4202-e1a7-c964-d17d6cfc9bef@me.com>
Content-Type: multipart/alternative;
 boundary=Apple-Webmail-42--c67fd816-cc34-6dab-a21c-8649923afba7
MIME-Version: 1.0
In-Reply-To: <AANLkTi=71_f+jk8KpECJ3eG1_ABGJy2F5LaD6ZH_P2jv@mail.gmail.com>
Date: Sun, 25 Jul 2010 17:04:37 -0700 (PDT)


--Apple-Webmail-42--c67fd816-cc34-6dab-a21c-8649923afba7
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
    charset=utf-8;
    format=flowed

Have a look at how the SliceRange works  for both get_slice and KeyRange w=
orks for get_range_slices.=0A=0AYou can query for things that start with a=
 sub string but specifying a start value and an empty end value or an end =
value that is the start value concatenated with the max ascii character. T=
hen just make multiple calls, say getting 1000 cols/rows at a time.=0A=0AY=
ou cannot do a "contains" type query, it's just byte/string matching. You'=
ll need to think about how to store your data in a way that lets you get t=
he same result. For example you could store the keys in the a Column Famil=
y for "all" and a CF for ones that have a sub part. Or your could store ju=
st "root@foo" as the key, then store columns for every child.=0A=0ANot gre=
at examples but the general idea is to denormalise to support the queries.=
=0A=0AHope that helps=0AAaron=0A=EF=BB=BF=0AOn 26 Jul, 2010,at 01:05 AM, M=
iriam Allalouf <miriam.allalouf@gmail.com> wrote:=0A=0A> Hi,=0A> I need to=
 build a mode where I can retrieve an ordered list of objects=0A> sharing =
the same prefix and contains a certain delimiter.=0A>=0A> For example: Get=
 all the object names that start with 'root' and=0A> contain '/' in it,=0A=
> given the names:=0A> root@abc/ddd=0A> roo@bbb/c=0A> root@pppp=0A>=0A> sh=
ould return the first two names (root@abc/ddd roo@bbb/c)=0A>=0A> I can bui=
ld the model such that the a lot object name is a key or a column name.=0A=
> Can we retrieve a key or a column name using such filter or other=0A> re=
gular expression-like filters?=0A> Thanks and I will appreciate you help,=0A=
> Miriam=0A
--Apple-Webmail-42--c67fd816-cc34-6dab-a21c-8649923afba7
Content-Type: multipart/related;
    type="text/html";
    boundary=Apple-Webmail-86--c67fd816-cc34-6dab-a21c-8649923afba7


--Apple-Webmail-86--c67fd816-cc34-6dab-a21c-8649923afba7
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
    charset=ISO-8859-1;

<html><body><div>Have a look at how the SliceRange works&nbsp; for both get_slice and =
KeyRange works for get_range_slices. <br><br>You can query for things that=
 start with a sub string but specifying a start value and an empty end val=
ue or an end value that is the start value concatenated with the max ascii=
 character. Then just make multiple calls, say getting 1000 cols/rows at a=
 time. <br><br>You cannot do a "contains" type query, it's just byte/strin=
g matching. You'll need to think about how to store your data in a way tha=
t lets you get the same result. For example you could store the keys in th=
e a Column Family for "all" and a CF for ones that have a sub part. Or you=
r could store just "root@foo" as the key, then store columns for every chi=
ld. <br><br>Not great examples but the general idea is to denormalise to s=
upport the queries. <br></div><div><br>Hope that helps<br>Aaron<br><br>On =
26 Jul, 2010,at 01:05 AM, Miriam Allalouf &lt;miriam.allalouf@gmail.com&gt=
; wrote:<br><br><div><blockquote type=3D"cite"><div><div class=3D"_stretch=
">Hi,<br>=0AI need to build a mode where I can retrieve an ordered list of=
 objects<br>=0Asharing the same prefix and contains a certain delimiter.<b=
r>=0A<br>=0AFor example:  Get all the object names that start with 'root' =
and<br>=0Acontain '/' in it,<br>=0Agiven the names:<br>=0Aroot@abc/ddd<br>=
=0Aroo@bbb/c<br>=0Aroot@pppp<br>=0A<br>=0Ashould return the first two name=
s (root@abc/ddd  roo@bbb/c)<br>=0A<br>=0AI can build the model such that t=
he a lot object name is a key or a column name.<br>=0ACan we  retrieve a k=
ey or a column name using such filter or other<br>=0Aregular expression-li=
ke filters?<br>=0AThanks and I will appreciate  you help,<br>=0AMiriam<br>=
=0A</div></div></blockquote></div></div></body></html>
--Apple-Webmail-86--c67fd816-cc34-6dab-a21c-8649923afba7--

--Apple-Webmail-42--c67fd816-cc34-6dab-a21c-8649923afba7--