Cassandra Full Text Search

Question

Let's say I have a family of columns called "Questions as shown below: Questions = {Who are you: {username:" user1 "}, What is the answer: {username:" user1 "} ...}

How to search for all questions containing specific words? Get all questions containing the word "what." How to do this with python or at least Java?

Answer 1

Solandra ( https://github.com/tjake/Solandra ) is the new name for Lucandra.

Solandra is a combination of Cassandra and Solr (based on the Lucene full-text search engine).

Only Cassandra does not search for text, although you can implement some basic text indexing by creating secondary column indexes (Google: optional cassandra index).

Answer 2

I am new to Cassandra, but the queries in it are relatively limited, compared, for example, with a relational database. (This is by design.) I am pretty sure that there is currently no full-text search support (it may not even be on the roadmap).

You might be better off going with Lucene or something similar to index the text of the questions, whether in the Cassandra data store or in a separate data store.

• http://lucene.apache.org/java/docs/index.html

It seems that there is at least one project that is trying to integrate Lucene with Cassandra, and there may be others:

• http://github.com/tjake/Lucandra

Another way to go in your case may be to break questions into words and keep your own index of words into questions; your mileage may vary here, and something like Lucene will surely give you more flexibility when requesting.

Answer 3

It looks like you could add "DSE Search" from people who support Cassandra, and you will have what you need. Lucene / Solr, but all the data stored in Cassandra.

http://www.datastax.com/dev/blog/cassandra-with-solr-integration-details

You have a good solution given by the last person, but this solution may serve your purpose better in terms of usability.

Disclaimer: I work for a NoSQL provider, but not on Kassandra.