cassandra cql order by实验 1CREATE TABLE simplex.playlists (2 id uuid,3 title text,4 num int,5 album text,6 artist text,7 song_id uuid,8 PRIMARY KEY (id,title,num)9 );1SELECT * FROM simplex.playlists where id=2cc9ccb7-6221-4ccb-8387-f22b6a
cassandra cql order by实验
1
CREATE TABLE simplex.playlists (
2
id uuid,
3
title text,
4
num int,
5
album text,
6
artist text,
7
song_id uuid,
8
PRIMARY KEY (id,title,num)
9
);
1
SELECT * FROM simplex.playlists where id=2cc9ccb7-6221-4ccb-8387-f22b6a1b354d ORDER BY title DESC;
1
搜索成功
1
SELECT * FROM simplex.playlists where id=2cc9ccb7-6221-4ccb-8387-f22b6a1b354d ORDER BY num DESC;
1
搜索异常Order by currently only support the ordering of columns following their declared order in the PRIMARY KEY
1
SELECT * FROM simplex.playlists ORDER BY title DESC;
1
异常：ORDER BY is only supported when the partition key is restricted by an EQ or an IN.
1
SELECT * FROM simplex.playlists where num=1 ORDER BY title DESC;
1
异常：PRIMARY KEY part num cannot be restricted (preceding part title is either not restricted or by a non-EQ relation
1
SELECT * FROM simplex.playlists where title='La Petite Tonkinoise' ORDER BY title DESC;
1
异常：ORDER BY is only supported when the partition key is restricted by an EQ or an IN.
1
SELECT * FROM simplex.playlists where id=2cc9ccb7-6221-4ccb-8387-f22b6a1b354d ORDER BY id DESC;
1
异常：Order by is currently only supported on the clustered columns of the PRIMARY KEY, got id
1
SELECT * FROM simplex.playlists where title='La Petite Tonkinoise' ORDER BY num DESC;
1
异常：ORDER BY is only supported when the partition key is restricted by an EQ or an IN.
1
通过以上实验可以得出cassandra cql order by 字段必须是复合主键的第二个字段，并且需要where后跟上第一个字段的条件判断。
1
另外：CLUSTERING ORDER
01
<span>
02
03
04
05
06
07
08
09
10
11
<ul>
12
<li> 官方说明 </li>
13
<li> if the table has been defined without any specific CLUSTERING ORDER, then then allowed orderings are the order induced by the clustering key and the reverse of that one. </li>
14
<li> otherwise, the orderings allowed are the order of the CLUSTERING ORDER option and the reversed one. </li>
15
</ul>
16
用法是 ：WITH CLUSTERING ORDER BY( title DESC) 跟在建表语句后面。目的是改变数据存储排序方式
