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> 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> 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? >> >
