cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aaron Turner <synfina...@gmail.com>
Subject Re: CQL + Counters = bad request
Date Wed, 13 Jul 2011 17:37:23 GMT
I've tried using the Thrift/execute_cql_query() API as well, and it
doesn't work either.  I've also tried using a CF where the column
names are of AsciiType to see if that was the problem (quoted and
unquoted column names) and I get the exact same error of: no viable
alternative at character '+'

Frankly, I'm about ready to open a ticket against 0.8.1 saying
CQL/Counter support does not work at all.

Or is there a trick which isn't documented in the ticket?  I tried
reading the Java code referred to in ticket #2473, but i'm over my
head.

On Tue, Jul 12, 2011 at 6:46 PM, Aaron Turner <synfinatic@gmail.com> wrote:
> Doesn't seem to help:
>
> cqlsh> UPDATE RouterAggWeekly SET '1310367600' = '1310367600' + 17
> WHERE KEY = '1_20110728_ifoutmulticastpkts';
> Bad Request: line 1:55 no viable alternative at character '+'
>
> cqlsh> UPDATE RouterAggWeekly SET 1310367600 = '1310367600' + 17 WHERE
> KEY = '1_20110728_ifoutmulticastpkts';
> Bad Request: line 1:53 no viable alternative at character '+'
>
> cqlsh> UPDATE RouterAggWeekly SET '1310367600' = 1310367600 + 17 WHERE
> KEY = '1_20110728_ifoutmulticastpkts';
> Bad Request: line 1:53 no viable alternative at character '+'
>
> On Tue, Jul 12, 2011 at 5:35 PM, Jonathan Ellis <jbellis@gmail.com> wrote:
>> Try quoting the column name.
>>
>> On Tue, Jul 12, 2011 at 5:30 PM, Aaron Turner <synfinatic@gmail.com> wrote:
>>> Using Cassandra 0.8.1 and cql 1.0.3 and following the syntax mentioned
>>> in https://issues.apache.org/jira/browse/CASSANDRA-2473
>>>
>>> cqlsh> UPDATE RouterAggWeekly SET 1310367600 = 1310367600 + 17 WHERE
>>> KEY = '1_20110728_ifoutmulticastpkts';
>>> Bad Request: line 1:51 no viable alternative at character '+'
>>>
>>> Column names are Long's, hence the INT = INT + INT
>>>
>>> Ideas?
>>>
>>> --
>>> Aaron Turner
>>> http://synfin.net/         Twitter: @synfinatic
>>> http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Windows
>>> Those who would give up essential Liberty, to purchase a little temporary
>>> Safety, deserve neither Liberty nor Safety.
>>>     -- Benjamin Franklin
>>> "carpe diem quam minimum credula postero"
>>>
>>
>>
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of DataStax, the source for professional Cassandra support
>> http://www.datastax.com
>>
>
>
>
> --
> Aaron Turner
> http://synfin.net/         Twitter: @synfinatic
> http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Windows
> Those who would give up essential Liberty, to purchase a little temporary
> Safety, deserve neither Liberty nor Safety.
>     -- Benjamin Franklin
> "carpe diem quam minimum credula postero"
>



-- 
Aaron Turner
http://synfin.net/         Twitter: @synfinatic
http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Windows
Those who would give up essential Liberty, to purchase a little temporary
Safety, deserve neither Liberty nor Safety.
    -- Benjamin Franklin
"carpe diem quam minimum credula postero"

Mime
View raw message