cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "@Nandan@" <nandanpriyadarshi...@gmail.com>
Subject Re: LIKE
Date Wed, 21 Jun 2017 09:49:16 GMT
If you are sure , that you want to do LIKE , then you can go with SASI .

https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html
Hope this will help you .

On Wed, Jun 21, 2017 at 2:44 PM, web master <socketman2016@gmail.com> wrote:

> I have this table
>
> CREATE TABLE users_by_username (
>     username text PRIMARY KEY,
>     email text,
>     age int
> )
>
> I want to run query like the following
>
> select username from users where username LIKE 'shl%' LIMIT 10;
>
>
> Always , I want to find only 10 username (Case insensitive) that start
> with specific characters , How can I do it efficient? I want to read
> minimum partitions and best performance
>
>

Mime
View raw message