How can I replace like operator in Cassandra?

Question

I am a beginner in cassandra DB. in mysql you can use like operator. For example if I want to to filter names of all those people who have "Michael" in their full name. How can I perform it in Cassandra?

The output should be like

"Michael Jackson"
"Kamraan Micheal"
"Michael kern"

Carlo Bertuccini · Accepted Answer · 2014-11-16 19:51:54Z

1

You can't. Cassandra is a key based data store -- this kind of problem is resolved by putting a full text search engine beside Cassandra (like solr/elastic search) -- Datastax enterprise offers the solution described using solr. HTH, Carlo

answered Nov 16, 2014 at 19:51

Carlo Bertuccini

20.1k3 gold badges31 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ateeq Ur Rehman Over a year ago

Thank You! it is real helpful.

Collectives™ on Stack Overflow

How can I replace like operator in Cassandra?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related