Cassandra Non-Counter Family

Question

I'm attempted to execute the following CQL 3 statement

 CREATE TABLE summary (
                id uuid,
                "client" bigint, 
                "campaign" text, 
                "unit" bigint,
                "view" counter,
                PRIMARY KEY ("client", "campaign", "unit"));

The error I'm getting is that I cannot create a counter column on a non-counter column family.

Any ideas?

score 13 · Answer 1 · answered Oct 27 '13 at 17:27

13

The solution to this issue is that any non-counter column must be part of the primary key. The column id uuid was the one causing the issue, removing it allowed the table to be created.

answered Oct 27 '13 at 17:27

Dharun

613
8
26

score 6 · Answer 2 · answered Oct 25 '13 at 20:10

6

Tables that contain counters can only contain counters.

answered Oct 25 '13 at 20:10

jbellis

19,347
2
38
47

So it can have only counters and a single key? – Dharun Oct 25 '13 at 23:44
multiple primary keys are accepted: http://docs.datastax.com/en/cql/3.0/cql/cql_using/use_counter_t.html – Mullefa May 30 '15 at 23:23

score 0 · Answer 3 · edited May 23 '17 at 12:10

0

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.

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

(migrated from Cassandra non counter family)

edited May 23 '17 at 12:10

Community

1
1

answered Apr 07 '17 at 08:49

Andremoniy

34,031
20
135
241

Cassandra Non-Counter Family

3 Answers3

Linked