Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates
 74.125.82.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=Y4fUWJJ0W+qjOlh97Lwf2EAx51crrZ8BmUT7nm7sDKoPX9SNpIX/Kdq049Ic01THEO
         gmjL9fquOrmX3YgHh2uRB7XS5Z35I/ymEeSwMhC7t69isvenLFT4l8SmdXj+W6iZsO6n
         6LqDjJ6neZcVuyu8l9+qUsDg5IocKaJlr6dio=
MIME-Version: 1.0
In-Reply-To: <BANLkTi=NB4BE2gJ_tXBVP=qQ7TUd1heUkA@mail.gmail.com>
References: <BANLkTi=NB4BE2gJ_tXBVP=qQ7TUd1heUkA@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Sat, 4 Jun 2011 00:25:48 -0500
Message-ID: <BANLkTikUWHfT2425=VTQ4gYCxh8GHyQJ6Q@mail.gmail.com>
Subject: Re: New SecondaryIndex expression=IndexOperator.LIKE
To: dev@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I suppose you could do a STARTS WITH but I don't know that it's worth
special casing as an operator since you get most of the benefit with
just GTE.

-1 on a generic LIKE that's mostly no more efficient than paging
through manually.

On Fri, Jun 3, 2011 at 10:15 PM, Joseph Stein <cryptcom@gmail.com> wrote:
> Hey folks, I was contemplating having a LIKE type search on Secondary
> Indexes.
>
> LIKE_S, S_LIKE and S_LIKE_S (similiar to LIKE '%eg', 'eg% and '%eg%'
>
> I am not sure if this has already been discussed or even an existing JIRA=
 or
> maybe something maybe I could contribute myself?
>
> It looks like the best way to-do this would be to add some additional
> properties to IndexExpression so we know we want to-do a LIKE check
>
> pseudo coding my thoughts taking this from ColumnFamilyStore
>
> int v =3D
> data.metadata().getValueValidator(expression.column_name).compare(column.=
value(),
> expression.value);
> =A0 =A0 =A0 =A0 =A0 =A0if (!satisfies(v, expression.op))
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0return false;
>
> and make it something like this
>
> if (expression.LIKE) {
> =A0if (!column.MakeItAStringValue().equalsIgnoreCase(express.value)) =A0/=
/this
> would actually fall into a switch for S_LIKE, LIKE_S, S_LIKE_S
> =A0 =A0return false;
> else {
> int v =3D
> data.metadata().getValueValidator(expression.column_name).compare(column.=
value(),
> expression.value);
> =A0 =A0 =A0 =A0 =A0 =A0if (!satisfies(v, expression.op))
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0return false;
> }
>
> am i on the right track? =A0smoking crack?
>
> let me know please
>
> /*
> Joe Stein
> http://www.linkedin.com/in/charmalloc
> Twitter: @allthingshadoop
> */
>


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com