cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benjamin Roth <benjamin.r...@jaumo.com>
Subject Re: Cannot mix counter and non counter columns in the same table
Date Tue, 01 Nov 2016 18:05:45 GMT
Big Fat lol!!!

Am 01.11.2016 19:02 schrieb "Ali Akhtar" <ali.rac200@gmail.com>:

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

Mime
View raw message