I had SASI in mind before stopping myself from replying to this thread. Actually the OP needs to index clustering column and partition key, and as far as I remember, I've myself opened a JIRA and pushed a patch for SASI to support indexing composite partition key but there are some issues so far preventing this to be merged into trunk
https://issues.apache.org/jira/browse/CASSANDRA-11734 https://issues.apache.org/jira/browse/CASSANDRA-13228 On Tue, Jul 31, 2018 at 5:17 PM, Jordan West <jorda...@gmail.com> wrote: > > > On Tue, Jul 31, 2018 at 7:45 AM, onmstester onmstester < > onmstes...@zoho.com> wrote: > >> I need to do a full text search (like) on one of my clustering keys and >> one of partition keys (it use text as data type). >> > > For simple LIKE queries on existing columns you could give SASI ( > https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html) > a try without having to stand up a separate piece of software. Its > relatively new and isn’t as battle tested as other parts of Cassandra but > it has been used in production. There are some performance issues with > wider-CQL partitions if you have those (https://issues.apache.org/ > jira/browse/CASSANDRA-11990). I hope to address that for 4.0, time > permitted. > > Full disclosure, I was one of the original SASI authors. > > >> The input rate is high so only Cassandra could handle it, Is there any >> open source version project which help using cassandra+ solr or cassandra + >> elastic? >> Any Recommendation on doing this with home-made solutions would be >> appreciated? >> >> Sent using Zoho Mail <https://www.zoho.com/mail/> >> >> > > >
