我的表架构是：

CREATE TABLE users
(user_id BIGINT PRIMARY KEY, 
user_name text, 
email_ text);

我把下面几行插入表格。

INSERT INTO users(user_id, email_, user_name)
VALUES(1, 'abc@test.com', 'ABC');

INSERT INTO users(user_id, email_, user_name)
VALUES(2, 'abc@test.com', 'ZYX ABC');

INSERT INTO users(user_id, email_, user_name)
VALUES(3, 'abc@test.com', 'Test ABC');

INSERT INTO users(user_id, email_, user_name)
VALUES(4, 'abc@test.com', 'C ABC');

用于将数据搜索到 user_name 列中，我创建了一个索引来使用 LIKE 操作员 '%%' :

CREATE CUSTOM INDEX  idx_users_user_name ON users (user_name)
USING 'org.apache.cassandra.index.sasi.SASIIndex'
WITH OPTIONS = {
'mode': 'CONTAINS',
'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer', 
'case_sensitive': 'false'};

problem:1 when 我正在执行下面的查询，它只返回3条记录，而不是4条。

select * 
from users 
where user_name like '%ABC%';

problem:2 when 我用下面的查询，它给出了一个错误

ERROR: com.datastax.driver.core.exceptions.InvalidQueryException: 
ORDER BY with 2ndary indexes is not supported. 
Query =select * from users where user_name like '%ABC%' ORDER BY user_name ASC;

查询：

select * 
from users 
where user_name like '%ABC%' 
ORDER BY user_name ASC;

我的要求是过滤 user_name 与 order by user_name .