复合键和计数器.我可以创建列系列，但无法填充它

Question

我知道一个计数器系列可以有任何类型的钥匙。是否不支持组合键？

 cqlsh:goh_master> create columnfamily balance (kind ascii, corporation_id ascii, amount  counter, primary key ( kind,corporation_id) ) with compact storage;
 cqlsh:goh_master> insert into balance(kind,corporation_id,amount) values ('c',103,123456789);
 Bad Request: invalid operation for commutative columnfamily balance
 cqlsh:goh_master> create columnfamily balance (kind ascii, corporation_id ascii, amount counter, primary key ( kind,corporation_id) ) with compact storage;
 cqlsh:goh_master> insert into balance(kind,corporation_id,amount) values ('c',103,123456789);
 Bad Request: invalid operation for commutative columnfamily balance

Answer 1

多

亏了这个答案，我自己解决了。您不能插入计数器，也不能只是设置。您必须始终使用设置计数器 =计数器 +n 语法：

cqlsh:goh_master> update balance set amount=amount+12 where kind='c' and corporation_id = 103;

像魅力一样工作