cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From web master <>
Subject LIKE
Date Wed, 21 Jun 2017 06:44:02 GMT
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

View raw message