How to read cassandra data in case in-sensitive way : Case in-sensitive CQL query
Like in SQL there is way to query
select * from users where upper(first_name) = 'TEST';
So whats the alternative in CQL /Cassandra to read data in case in-sensitive way ?
CQL does not natively support case-insensitive data retrieval. Cassandra is optimised for extremely fast data retrieval so filters (WHERE clause) must be an exact match.
For complex filtering, you need to index your data with software like Apache Solr or Elasticsearch so you can do more advanced free-form searches that can perform fuzzy matching. Cheers!
8 People are following this question.
