I am trying to implement seach functionality based on the title field of entries present in amazon keyspaces. I was trying to do a regex match on the title field but I am not to figure out how it could be done. Does amazon keyspace supports regex search? I am using the Datastax nodeJs driver for cassandra. Also I checked the documentation for amazon keyspace but could not find any useful information.
If anyone is familiar with this, please help me out.
On
That functionality doesn't exist because Cassandra is designed for OLTP workloads where the access pattern is optimised for retrieving one record by filtering on a specific partition key.
Since you have a complex search use case, the general recommendation is to use search engines based on Lucene such as Elasticsearch or Apache Solr. Both of those are capable of performing complex searches over indexed Cassandra data. Cheers!
No, as of 20230207, it is not possible to run a regex-based query on Amazon Keyspaces.