Is it possible to set a counter to zero using CQL?

2014-02-12 Thread Jacob Rhoden
Hi Guys, My question is probably best described by example. Is it possible to indicate that on a particular day, the total number of “events” were zero. // Three events today update mytable count=count+1 where day=“20140101” update mytable count=count+1 where day=“20140101” update mytable

Re: Is it possible to set a counter to zero using CQL?

2014-02-12 Thread Steven A Robenalt
Hi Jacob, I get the same effect using: update mytable set count = count + 0 where day = 20140103 The count field is changed from null to zero as a result. Steve On Wed, Feb 12, 2014 at 6:31 PM, Jacob Rhoden jacob.rho...@me.com wrote: Hi Guys, My question is probably best described by