Thanks Jordan, There would be millions of rows per day, is SASI capable of
standing such a rate? Sent using Zoho Mail On Tue, 31 Jul 2018 19:47:55
+0430 Jordan West wrote On Tue, Jul 31, 2018 at 7:45
AM, onmstester onmstester wrote: I need to do a full text
search (like) on one of m
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
pr
On Tue, Jul 31, 2018 at 7:45 AM, onmstester onmstester
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
