卡桑德拉非柜台家庭 [英] Cassandra non counter family

问题描述

我试图创建一个带有计数器的表作为cassandra中的列类型之一，但出现以下错误:

I attempted to create a table with counter as one of the column type in cassandra but getting the following error:

ConfigurationException:ErrorMessage代码= 2300 [查询无效，因为配置问题] message =无法添加计数器列(transaction_count)在非计数器列系列中"

ConfigurationException: ErrorMessage code=2300 [Query invalid because of configuration issue] message="Cannot add a counter column (transaction_count) in a non counter column family"

我的表架构如下:

CREATE TABLE MARKET_DATA_TRANSACTION_COUNT (
TRADE_DATE TIMESTAMP,      
SECURITY_EXCHANGE TEXT,
PRODUCT_CODE TEXT,
SYMBOL TEXT,
SPREAD_TYPE TEXT,     
USER_DEFINED TEXT,
PRODUCT_GUID TEXT,
CHANNEL_ID INT,  
SECURITY_TYPE TEXT,
INSTRUMENT_GUID TEXT,
SECURITY_ID INT,   
TRANSACTION_COUNT COUNTER,
PRIMARY KEY (TRADE_DATE));

推荐答案

这是当前计数器实现的限制.您不能在同一表格中混合使用计数器和常规列.因此，您需要一个单独的计数器表.

That's a limitation of the current counter implementation. You can't mix counters and regular columns in the same table. So you need a separate table for counters.

他们正在考虑在Cassandra 3.x中消除此限制.参见吉拉车票.

They are thinking of removing this limitation in Cassandra 3.x. See this Jira ticket.

这篇关于卡桑德拉非柜台家庭的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！