Big Fat lol!!! Am 01.11.2016 19:02 schrieb "Ali Akhtar" <ali.rac...@gmail.com>:
> ^ 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? >>>>>> >>>>> >>>> >> >> >
