cassandra - CQL : Bad Request: Missing CLUSTERING ORDER for column

Question

这个 CQL 查询有什么问题

cqlsh> create table citybizz.notifications(
   ...      userId varchar,
   ...      notifId UUID,
   ...      notification varchar,
   ...      time bigint,read boolean,
   ...      primary key (userId, notifId,time)
   ... ) with clustering order by (time desc);

它抛出 Bad Request: Missing CLUSTERING ORDER for column notifid .我正在使用 cassandra 1.2.2

Answer 1

您还需要指定 notifId 的顺序:

create table citybizz.notifications(
    userId varchar,
    notifId UUID,
    notification varchar,
    time bigint,read boolean,
    primary key (userId, notifId,time)
) with clustering order by (notifId asc, time desc);

Cassandra 不假定其他集群键的默认排序 (asc)，因此您需要指定它。