On 2017-06-20 23:44 (-0700), web master 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;
>
>
>
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 wrote:
> I have this table
>
> CREATE TABLE users_by_username (
> username