Vijayakumar
Reputation: 69
How to use like query in cassandra CQL?
I am a novice programmer to cassandra. I want to search records from cassandra database based on some text. For example I want to search records which are all contains "test". How can achieve this in cassandra.
Simply how to use mysql LIKE in cassandra ? Is there any other alternative for this ?
Upvotes: 1
Views: 702
Answers (1)
ShauTzin
Reputation: 21
LIKE isn't supported in Cassandra
The only way to do this efficiently is to use a full-text search engine like https://github.com/tjake/Solandra (Solr-on-cassandra)
Upvotes: 2
Related Questions
- Pattern matching 'like' on primary key in cassandra
- Is there any query for Cassandra as same as SQL:LIKE Condition?
- Sub string search like "LIKE" keyword in SQL
- How to use like operator in cassandra database?
- Like operator in cassandra
- How can I replace like operator in Cassandra?
- LIKE operator in Cassandra CQL
- How to query '%' character using LIKE operator in Cassandra 3.7?
- How to create like query in Cassandra?
- How to Search Value in Cassandra like 'WHERE' in SQL?