Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of synfinatic@gmail.com designates
 209.85.213.172 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CALdd-zjCpEhvfuc5Ks57yoCYhfKrh0d2=BgDVii33FtED7kJ3w@mail.gmail.com>
References: 
 <CANAZdzUeP=Do9t0Sh_pRVRyoM8kU4W9JL+Hdu6NafLsaf0V10g@mail.gmail.com>
 <CALdd-zjCpEhvfuc5Ks57yoCYhfKrh0d2=BgDVii33FtED7kJ3w@mail.gmail.com>
From: Aaron Turner <synfinatic@gmail.com>
Date: Tue, 12 Jul 2011 18:46:37 -0700
Message-ID: 
 <CANAZdzU5+465t3P7NUPZbBB0W5=W0r-N-cLbavez5WkRff-jMg@mail.gmail.com>
Subject: Re: CQL + Counters = bad request
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Doesn't seem to help:

cqlsh> UPDATE RouterAggWeekly SET '1310367600' =3D '1310367600' + 17
WHERE KEY =3D '1_20110728_ifoutmulticastpkts';
Bad Request: line 1:55 no viable alternative at character '+'

cqlsh> UPDATE RouterAggWeekly SET 1310367600 =3D '1310367600' + 17 WHERE
KEY =3D '1_20110728_ifoutmulticastpkts';
Bad Request: line 1:53 no viable alternative at character '+'

cqlsh> UPDATE RouterAggWeekly SET '1310367600' =3D 1310367600 + 17 WHERE
KEY =3D '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> wrot=
e:
>> 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 =3D 1310367600 + 17 WHERE
>> KEY =3D '1_20110728_ifoutmulticastpkts';
>> Bad Request: line 1:51 no viable alternative at character '+'
>>
>> Column names are Long's, hence the INT =3D INT + INT
>>
>> Ideas?
>>
>> --
>> Aaron Turner
>> http://synfin.net/=A0 =A0 =A0 =A0=A0 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 temporar=
y
>> Safety, deserve neither Liberty nor Safety.
>> =A0 =A0 -- 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
>


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