• 创建表 

create table if not exists user_unique_id_actor
(id bigint ,content text,create_time bigint,modify_time bigint,msg_type int,status int,self_unique_id text,user_unique_id text,primary key(id,create_time)
)with CLUSTERING ORDER BY (create_time asc )and caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}and compaction = {'max_threshold': '32', 'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}and compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor', 'chunk_length_in_kb': '64'}and dclocal_read_repair_chance = 0.1;

• 查询

1. 排序查询
2. 子查询
3. 分页查询

 成功得查询

排序查询
select * from demo.user_unique_id_actor where id = 5322082955517954 order by create_time desc
子查询
select * from demo.user_unique_id_actor where user_unique_id = '2' and status = 0 and msg_type = 1 allow filtering 

失败的查询

select * from demo.user_unique_id_actor order by create_time desc

语法比oracle还严格的多的多，后续更新