From user-return-5757-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Thu May 13 22:19:42 2010 Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 45551 invoked from network); 13 May 2010 22:19:42 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 13 May 2010 22:19:42 -0000 Received: (qmail 8594 invoked by uid 500); 13 May 2010 22:19:41 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 8570 invoked by uid 500); 13 May 2010 22:19:41 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 8562 invoked by uid 99); 13 May 2010 22:19:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 May 2010 22:19:41 +0000 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=AWL,FREEMAIL_FROM,HTML_MESSAGE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of beiercai@gmail.com designates 209.85.161.44 as permitted sender) Received: from [209.85.161.44] (HELO mail-fx0-f44.google.com) (209.85.161.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 May 2010 22:19:36 +0000 Received: by fxm16 with SMTP id 16so457254fxm.31 for ; Thu, 13 May 2010 15:19:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:content-type; bh=FM9zU1ju2Ww6nIItE8sJxZ/2/gWAckx99EMFXd1jt1Y=; b=LuaOe/XLqKMhcwtHRI1MPZnDy+2KGoYMhEyCTw2gDY47HJj+WSArkCG365HuGFVeEE RIBBkzxQl70a03hu1vXesRi7zVCe63US0XNXMRn/WhjiNHnPnYmPjoB8ipKoVNfl1HVl 99zNfu6ZR5Bk4oPaEmNLnM1VOQwDRJqek9LhQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=UlmI90FhOhkPx5skfffHXkXTAx7dwVfHjUuLrageAnKCG6VC12u6XPOa3iQYBRMWBB a2xLCeSOH72WMVgGO2jEXcFzuV5JfShoZIian/KXoNvgrhNV9+/OgpNS1Q5RiVRwFhQs fqx/Z+pSO7HiB1wJVAiN34VTzqbBDee2ad48w= Received: by 10.204.128.68 with SMTP id j4mr218745bks.49.1273789155195; Thu, 13 May 2010 15:19:15 -0700 (PDT) MIME-Version: 1.0 Received: by 10.204.54.145 with HTTP; Thu, 13 May 2010 15:18:55 -0700 (PDT) In-Reply-To: References: From: Beier Cai Date: Thu, 13 May 2010 15:18:55 -0700 Message-ID: Subject: Re: Increment and Decrement operation To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=0015174a0ef41d3d5f04868126c5 --0015174a0ef41d3d5f04868126c5 Content-Type: text/plain; charset=ISO-8859-1 Thanks for the info, hopefully it will make it to the next version Beier, Cai beiercai@gmail.com On Thu, May 13, 2010 at 2:28 PM, Paul Prescod wrote: > No, but there is ongoing work on it: > > * https://issues.apache.org/jira/browse/CASSANDRA-580 > > * http://www.formspring.me/joestump/q/420668558 > > * http://permalink.gmane.org/gmane.comp.db.cassandra.user/3740 > > And in the meantime, an interim patch: > > * https://issues.apache.org/jira/browse/CASSANDRA-721 > > On Thu, May 13, 2010 at 2:04 PM, Beier Cai wrote: > > Is it possible to increment/decrement a column value directly without > > reading it first and then do the operation on client side? In mysql you > can > > do "UPDATE mytable SET counter=counter+1", any equivalent in Cassandra? > > > > Beier, Cai > > beiercai@gmail.com > > > --0015174a0ef41d3d5f04868126c5 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Thanks for the info, hopefully it will make it to the next version
Beier, Cai
bei= ercai@gmail.com


On Thu, May 13, 2010 at 2:28 PM, Paul Pr= escod <paul@presco= d.net> wrote:
No, but there is ongoing work on it:

=A0* https://issues.apache.org/jira/browse/CASSANDRA-580

=A0* http://www.formspring.me/joestump/q/420668558

=A0* http://permalink.gmane.org/gmane.comp.db.cassandra.use= r/3740

And in the meantime, an interim patch:

=A0* https://issues.apache.org/jira/browse/CASSANDRA-721

On Thu, May 13, 2010 at 2:04 PM, Beier Cai <beiercai@gmail.com> wrote:
> Is it possible to increment/decrement a column value directly without<= br> > reading it first and then do the operation on client side? In mysql yo= u can
> do "UPDATE mytable SET counter=3Dcounter+1", any equivalent = in Cassandra?
>
> Beier, Cai
> beiercai@gmail.com
>

--0015174a0ef41d3d5f04868126c5--