“仅当分区键受eq或in限制时才支持order by”cassandra

k10s72fa 于 2021-06-14 发布在 Cassandra

关注(0)|答案(1)|浏览(628)

我创建了这样的表。。

CREATE TABLE test1.mytest (
    id text,
    year text,
    time bigint,
    crtby text,
    data text,
    postid text,
    upby text,
    PRIMARY KEY ((id, year), time)
) WITH CLUSTERING ORDER BY (time DESC)

我想根据时间键对数据进行排序。

SELECT * FROM test1.mytest WHERE id ='b' ORDER BY time asc ALLOW FILTERING ;

当我尝试上述命令时，我得到

InvalidRequest: Error from server: code=2200 [Invalid query] message="ORDER BY is only supported when the partition key is restricted by an EQ or an IN."

cassandra database-design

来源：https://stackoverflow.com/questions/57488451/order-by-is-only-supported-when-the-partition-key-is-restricted-by-an-eq-or-an