cassandra3.5版本如下查询报错InvalidRequest: code=2200 [Invalid query] message="Clustering column "test3" cannot be restricted (preceding column "test2" is restricted by a non-EQ relation)":
如果以聚合键的方式查询则会报错InvalidRequest: code=2200 [Invalid query] message="Clustering column "test3" cannot be restricted (preceding column "test2" is restricted by a non-EQ relation)",这是因为聚合键约束限制。
解决:重新定义一个和被约束限制内容一样的聚合键,来充当被约束聚合键的筛选条件。
cassandra3.9版本中不存在此问题.