I used to think it was terrible as well. But it really isn’t. Just put your non-counter columns in a separate table with the same primary key. If you want to query both counter and non-counter columns at the same time, just query both tables at the same time with asynchronous queries.
On Nov 1, 2016, at 7:29 AM, Ali Akhtar <ali.rac...@gmail.com<mailto:ali.rac...@gmail.com>> wrote: That's a terrible gotcha rule. On Tue, Nov 1, 2016 at 6:27 PM, Cody Yancey <yan...@uber.com<mailto:yan...@uber.com>> wrote: In your table schema, you have KEYS and you have VALUES. Your KEYS are text, but they could be any non-counter type or compound thereof. KEYS obviously cannot ever be counters. Your VALUES, however, must be either all counters or all non-counters. The official example you posted conforms to this limitation. Thanks, Cody On Nov 1, 2016 7:16 AM, "Ali Akhtar" <ali.rac...@gmail.com<mailto:ali.rac...@gmail.com>> wrote: I'm not referring to the primary key, just to other columns. My primary key is a text, and my table contains a mix of texts, ints, and timestamps. If I try to change one of the ints to a counter and run the create table query, I get the error ' Cannot mix counter and non counter columns in the same table' On Tue, Nov 1, 2016 at 6:11 PM, Cody Yancey <yan...@uber.com<mailto:yan...@uber.com>> wrote: For counter tables, non-counter types are of course allowed in the primary key. Counters would be meaningless otherwise. Thanks, Cody On Nov 1, 2016 7:00 AM, "Ali Akhtar" <ali.rac...@gmail.com<mailto:ali.rac...@gmail.com>> wrote: In the documentation for counters: https://docs.datastax.com/en/cql/3.1/cql/cql_using/use_counter_t.html The example table is created via: CREATE TABLE counterks.page_view_counts (counter_value counter, url_name varchar, page_name varchar, PRIMARY KEY (url_name, page_name) ); Yet if I try to create a table with a mixture of texts, ints, timestamps, and counters, i get the error ' Cannot mix counter and non counter columns in the same table' Is that supposed to be allowed or not allowed, given that the official example contains a mix of counters and non-counters?
