How to use like operator in cassandra database?

Question

I am using cassandra database cassandra:2.2.3 in my application and i should use like operator to get all the names starts with 'A%'.

CREATE CUSTOM INDEX  empnames_idx ON d.emp (ename)
USING 'org.apache.cassandra.index.sasi.SASIIndex';

After creating the index when i run the below query :

select * from d.emp where ename like 'A%';

<Error from server: code=2000 [Syntax error in CQL query] message="line 1:49 no viable alternative at input 'LIKE' (...* from d.emp where ename like .....)"

Cassandra doesn't support the keyword LIKE https://stackoverflow.com/questions/9905795/is-there-any-query-for-cassandra-as-same-as-sqllike-condition — Yamini, Apr 05 '19 at 08:52
What version of cassandra are you using? there is no such thing as 6.0.2. — Chris Lohfink, Apr 05 '19 at 15:32

score 2 · Accepted Answer · answered Apr 05 '19 at 17:05

2

It's not supported until 3.4+ but should upgrade to 3.11.latest. You may want to configure your index as well, an excellent walkthrough is here: http://www.doanduyhai.com/blog/?p=2058

answered Apr 05 '19 at 17:05

Chris Lohfink

16,150
1
29
38

Thanks for the link. – Studentlearner Apr 05 '19 at 17:27

How to use like operator in cassandra database?

1 Answers1