4

i wanna to search in cassandra database. After much research, I found

Stratio’s Cassandra Lucene Index

Is there another way to simple search on Cassandra? I mean a simple search query something like in Mysql

I've used this query but his conclusion was wrong

select * from users where uname > 'sa' allow filtering;

Community
  • 1
  • 1
Saman Baboli
  • 98
  • 8

1 Answers1

2

It seems to me that you'd want to perform a text search on a non PRIMARY KEY column.

If that's the case, you could use a SSTable Attached Secondary Index (SASI) that would allow to exactly search as you wrote. Specifically, you'd need to create a CONTAINS index to perform inequality searches on text fields. You need Cassandra 3.4 and later.

xmas79
  • 5,060
  • 2
  • 14
  • 35