create table cd_ml_api.sf_leads (
id timeuuid,
email text ,
cdh_org text,
source_of_funds text ,
currency_purpose text ,
created_date timestamp,
last_modified_date timestamp,
PRIMARY KEY (email, last_modified_date)
) WITH CLUSTERING ORDER BY (id DESC);
Cassandra终端显示错误:
invalidrequest:来自服务器的错误:code=2200[无效查询]
message=“缺少列上次修改日期的聚类顺序”
1条答案
按热度按时间mitkmikd1#
cassandra只能按聚类键排序。为了按id排序,它必须是集群键的一部分。