LIKE operator in Cassandra CQL

2
votes

I'm new to Cassandra and I need to do a text search through one or more VARCHAR type fileds using CQL and PHP. Usually with MySQL I used the LIKE operator but as I know in Cassandra is not possible, which is the alternative for do that in CQL? Note that I'm using Cassandra version 2.2.1 and the DataStax PHP-Driver.

1
phpcassandracqlcassandra-2.0nosql
possible duplicate of Is there any query for Cassandra as same as SQL:LIKE Condition? - uri2x
It looks like duplicate but it is not - that question is about "Cassandra 0.8.x" and current is about "Cassandra 2.2.1" so author hope that LIKE s appear, I suppose. - Andriy Kuba
Sorry, I didn't see this question in search during the post creation but as I seen later it is referred to an old version of Cassandra and I didn't find a proper solution. - RyanJ

1 Answers

1
votes

There is no LIKE operator in cassandra. It's "by design". You must use elasticsearch (Solr, Lucene) or similar solutions beside cassandra to develop search abilities.