^ Stockholm syndrome :) On Tue, Nov 1, 2016 at 10:54 PM, Robert Wille <rwi...@fold3.com> wrote:
> 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> wrote: > > That's a terrible gotcha rule. > > On Tue, Nov 1, 2016 at 6:27 PM, Cody Yancey <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> 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> 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? >>>>> >>>> >>> > >
