Support LIKE queries for Cassandra with SASI

[yhilem]

Hi,
Since Cassandra 3.4, LIKE queries can be achieved using a SSTable Attached Secondary Index (SASI).
JPQL supports the SQL LIKE operator to provide a limited form of string pattern matching.
Is this feature supported with SASI?
Thanks
Y. HILEM

[devender-yadav]

No this is not supported.

[yhilem]

If i create SASI index:

CREATE CUSTOM INDEX user_last_name_sasi_idx ON user (last_name)
 USING 'org.apache.cassandra.index.sasi.SASIIndex';

I can normally use the following native query to find users whose last name begins with “N”:
SELECT * FROM user WHERE last_name LIKE 'N%';
However, it depends on the resolution of this issue #1029.