Yep there was an issue here. RPM has been updated to 0.8.1-2 and
deployed. Thanks for tracking this down.
On Wed, Jul 13, 2011 at 3:58 PM, Aaron Turner wrote:
> Thanks. Looks like we tracked down the problem to the datasax 0.8.1
> rpm is actually 0.8.0.
>
> rpm -qa | grep cassandra
> apache-cass
Thanks. Looks like we tracked down the problem to the datasax 0.8.1
rpm is actually 0.8.0.
rpm -qa | grep cassandra
apache-cassandra08-0.8.1-1
grep ' Cassandra version:' /var/log/cassandra/system.log | tail -1
INFO [main] 2011-07-13 12:04:31,039 StorageService.java (line 368)
Cassandra version:
>
> >>> cqlsh> UPDATE RouterAggWeekly SET 1310367600 = 1310367600 + 17 WHERE
> >>> KEY = '1_20110728_ifoutmulticastpkts';
> >>> Bad Request: line 1:51 no viable alternative at character '+'
>
I m able to insert it.
___
cqlsh>
cqlsh> UPDATE counts SET 1310367600 = 1310367600 +
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 '+'
F
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_ifoutmultica
Try quoting the column name.
On Tue, Jul 12, 2011 at 5:30 PM, Aaron Turner 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_
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 '+'
