Is it possible to do a case-insensitive query of column in CQL?

Question

question

amit.himani asked · May 09, 2020 at 04:25 PM

Is it possible to do a case-insensitive query of column in CQL?

Hi,

I have created table using below SQL: I want to run query to find all video by actor name (case insensitive)

CREATE TABLE video_by_actor(
    actor text,
    added_date timestamp,
    video_id timeuuid ,
    character_name text,
    description text ,
    encoding frozen<video_encoding>,
    tags set<text>,
    title text,
    user_id uuid,
    primary key ((actor), added_date)
) with clustering order by (added_date desc);

select * from video_by_actor where actor='Tom Hanks'

// I want to search all case eg. tom hanks, Tom hanks, tom Hanks etc.

Is it possible?

cassandra

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Answer 1 · 2020-05-10T18:53:15Z

alexandre.dutra answered · May 10, 2020 at 06:53 PM

This is not possible with regular CQL queries, but you have a few options:

Create a special column in your table to store the normalized string that you want to search.
Use a SASI index.
Use DSE Search.

Share

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

question