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 <synfina...@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 <jbel...@gmail.com> wrote: >> Try quoting the column name. >> >> On Tue, Jul 12, 2011 at 5:30 PM, Aaron Turner <synfina...@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"
