Re: Counter Column

2014-12-27 Thread Eric Stevens
Having the client pass the timestamp is optional, if you do not provide one from the client, then it will use the server's timestamp. On Sat, Dec 27, 2014, 6:25 AM Phil Yang wrote: > sorry for typo.. timestamp which Cassandra uses is independent on the > timezone. > > Usually, it is recommended

Re: Counter Column

2014-12-27 Thread Phil Yang
sorry for typo.. timestamp which Cassandra uses is independent on the timezone. Usually, it is recommended to use NTP to reduce the difference of timestamps in each nodes 2014-12-27 21:20 GMT+08:00 Phil Yang : > In java, > http://docs.oracle.com/javase/7/docs/api/java/lang/System.html#currentTim

Re: Counter Column

2014-12-27 Thread Phil Yang
In java, http://docs.oracle.com/javase/7/docs/api/java/lang/System.html#currentTimeMillis() return "the difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC." It means the timestamp which Cassandra uses is not independent on the timezone. 2014-12-27 21:0

Re: Counter Column

2014-12-27 Thread Ajay
Thanks. I went through some articles which mentioned that the client to pass the timestamp for insert and update. Is that anyway we can avoid it and Cassandra assume the current time of the server? Thanks Ajay On Dec 26, 2014 10:50 PM, "Eric Stevens" wrote: > Timestamps are timezone independent

Re: Counter Column

2014-12-26 Thread Eric Stevens
Timestamps are timezone independent. This is a property of timestamps, not a property of Cassandra. A given moment is the same timestamp everywhere in the world. To display this in a human readable form, you then need to know what timezone you're attempting to represent the timestamp as, this is

Re: Counter column impossible to delete and re-insert

2014-11-06 Thread DuyHai Doan
Hello Clément This is a known anti-pattern. You should never re-use a deleted counter column otherwise there will be unpredictable result for the counter value. Le 6 nov. 2014 08:45, "Clément Fumey" a écrit : > Hi, > > I have a table with counter column . When I insert (update) a row, delete > i

Re: Counter column families (pending replicate on write stage tasks)

2012-11-12 Thread Rob Coli
On Mon, Nov 12, 2012 at 3:35 PM, cem wrote: > We are currently facing a performance issue with counter column families. I > see lots of pending ReplicateOnWriteStage tasks in tpstats. Then I disabled > replicate_on_write. It helped a lot. I want to use like that but I am not > sure how to use it.

Re: Counter column family

2012-04-18 Thread Tamar Fraenkel
My problem was the result of Hector bug, see http://groups.google.com/group/hector-users/browse_thread/thread/8359538ed387564e So please ignore question, Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54

Re: counter column family

2012-04-04 Thread aaron morton
e.g. +3. > > > 2012/3/27 Rishabh Agrawal > You can even define how much increment you want. But let me just warn you, as > far my knowledge, it has consistency issues. > > > From: puneet loya [mailto:puneetl...@gmail.com] > Sent: Tuesday, March 27, 2012 5:59 PM >

Re: counter column family

2012-04-03 Thread Tamar Fraenkel
uch increment you want. But let me just warn >> you, as far my knowledge, it has consistency issues. >> >> >> >> *From:* puneet loya [mailto:puneetl...@gmail.com] >> *Sent:* Tuesday, March 27, 2012 5:59 PM >> >> *To:* user@cassandra.apache.org >

RE: Counter Column

2012-04-03 Thread Jeremiah Jordan
t: Re: Counter Column this bug is for 0.8 beta 1, is it also relevant for 1.0.8? -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Counter-Column-tp7432010p7432450.html Sent from the cassandra-u...@incubator.apache.org mailing list archi

Re: Counter Column

2012-04-03 Thread Alain RODRIGUEZ
Sylvain explained a lot of things about counters at Cassandra SF 2011 : http://blip.tv/datastax/counters-in-cassandra-5497678 (video), http://www.datastax.com/wp-content/uploads/2011/07/cassandra_sf_counters.pdf(slides). I think it is always important knowing how the things work. Alain 2012/4/3

Re: Counter Column

2012-04-03 Thread Sylvain Lebresne
Again, it will be relevant until CASSANDRA-2495 is fixed. Until then (then being undefined so far), it affects all version that have counters (including 1.0.8). -- Sylvain On Tue, Apr 3, 2012 at 12:23 PM, Avi-h wrote: > this bug is for 0.8 beta 1, is it also relevant for 1.0.8? > > > -- > View t

Re: Counter Column

2012-04-03 Thread Sylvain Lebresne
On Tue, Apr 3, 2012 at 9:11 AM, Avi-h wrote: > I have encountered the following piece of information regarding the use of > ‘Counter Column’ in Cassandra: “If a write fails unexpectedly (timeout or > loss of connection to the coordinator node) the client will not know if the > operation has been p

Re: counter column family

2012-03-29 Thread Tyler Hobbs
On Tue, Mar 27, 2012 at 9:35 AM, puneet loya wrote: > now i want to have a field incrementing with every row insertion. how do i > do it in cassandra?? There's nothing that will do it automatically. You need to increment it yourself. -- Tyler Hobbs DataStax

Re: counter column family

2012-03-27 Thread puneet loya
of +1 have a result of e.g. +3. >> >> >> 2012/3/27 Rishabh Agrawal >> >>> You can even define how much increment you want. But let me just warn >>> you, as far my knowledge, it has consistency issues. >>> >>> >>> >&

Re: counter column family

2012-03-27 Thread Dave Brosius
issues. *From:*puneet loya [mailto:puneetl...@gmail.com <mailto:puneetl...@gmail.com>] *Sent:* Tuesday, March 27, 2012 5:59 PM *To:* user@cassandra.apache.org <mailto:user@cassandra.apache.org> *Subject:* Re: counter column family thanxx a ton

Re: counter column family

2012-03-27 Thread puneet loya
define how much increment you want. But let me just warn >> you, as far my knowledge, it has consistency issues. >> >> >> >> *From:* puneet loya [mailto:puneetl...@gmail.com] >> *Sent:* Tuesday, March 27, 2012 5:59 PM >> >> *To:* user@cassandra.apach

Re: counter column family

2012-03-27 Thread R. Verlangen
gt; > *From:* puneet loya [mailto:puneetl...@gmail.com] > *Sent:* Tuesday, March 27, 2012 5:59 PM > > *To:* user@cassandra.apache.org > *Subject:* Re: counter column family > > > > thanxx a ton :) :) > > > > the counter column family works synonymous as 

RE: counter column family

2012-03-27 Thread Rishabh Agrawal
You can even define how much increment you want. But let me just warn you, as far my knowledge, it has consistency issues. From: puneet loya [mailto:puneetl...@gmail.com] Sent: Tuesday, March 27, 2012 5:59 PM To: user@cassandra.apache.org Subject: Re: counter column family thanxx a ton

Re: counter column family

2012-03-27 Thread puneet loya
thanxx a ton :) :) the counter column family works synonymous as 'auto increment' in other databases rite? I mean we have a column of type integer which increments with every insert. Am i goin the rite way?? please reply :) On Tue, Mar 27, 2012 at 5:50 PM, R. Verlangen wrote: > *create colu

RE: counter column family

2012-03-27 Thread Rishabh Agrawal
As far as I know counter column family may pose serious consistency issues as they don't store timestamp. Correct me if I am wrong. From: R. Verlangen [mailto:ro...@us2.nl] Sent: Tuesday, March 27, 2012 5:50 PM To: user@cassandra.apache.org Subject: Re: counter column family create c

Re: counter column family

2012-03-27 Thread R. Verlangen
*create column family MyCounterColumnFamily with default_validation_class=CounterColumnType and key_validation_class=UTF8Type and comparator=UTF8Type;* There you go! Keys must be utf8, as well as the column names. Of course you can change those validators. Cheers! 2012/3/27 puneet loya > Can u

Re: Counter Column Family Inconsistent Node

2011-08-16 Thread Ryan Lowe
Actually I think it was more related to our servers getting their time out of sync... after finding this article: http://ria101.wordpress.com/2011/02/08/cassandra-the-importance-of-system-clocks-avoiding-oom-and-how-to-escape-oom-meltdown/ I checked our servers, and sure enough, 2 of them were out

Re: Counter Column Family Inconsistent Node

2011-08-16 Thread Jonathan Ellis
May be the same as https://issues.apache.org/jira/browse/CASSANDRA-3006 ? On Tue, Aug 16, 2011 at 12:20 PM, Ryan Lowe wrote: > yeah, sorry about that... pushed click before I added my comments. > I have a cluster of 5 nodes using 0.8.4 where I am using counters.  One one > of my nodes, every time

Re: Counter Column Family Inconsistent Node

2011-08-16 Thread Ryan Lowe
yeah, sorry about that... pushed click before I added my comments. I have a cluster of 5 nodes using 0.8.4 where I am using counters. One one of my nodes, every time I do a list command I get different results. The counters jump all over the place. Any ideas? I have run nodetool repair on all

Re: Counter Column

2011-06-28 Thread Sylvain Lebresne
On Tue, Jun 28, 2011 at 12:53 PM, Donal Zang wrote: > On 27/06/2011 19:19, Sylvain Lebresne wrote: >> >> Let me make that simpler. >> >> Don't ever use replicate_on_write=false (even if you "think" that it is >> what you want, there is a good chance it's not). >> Obviously, the default is replicat

Re: Counter Column

2011-06-28 Thread Donal Zang
On 27/06/2011 19:19, Sylvain Lebresne wrote: Let me make that simpler. Don't ever use replicate_on_write=false (even if you "think" that it is what you want, there is a good chance it's not). Obviously, the default is replicate_on_write=true. I may be wrong. But with 0.8.0, I think the default i

Re: Counter Column

2011-06-27 Thread Sylvain Lebresne
Let me make that simpler. Don't ever use replicate_on_write=false (even if you "think" that it is what you want, there is a good chance it's not). Obviously, the default is replicate_on_write=true. -- Sylvain On Mon, Jun 27, 2011 at 7:03 PM, Philippe wrote: > if i write at ALL and read at ONE,i

Re: Counter Column

2011-06-27 Thread Philippe
if i write at ALL and read at ONE,is that setting required ? thanks Le 27 juin 2011 17:22, "Donal Zang" a écrit : > On 27/06/2011 17:04, Artem Orobets wrote: >> >> Hi! >> >> As I know, we use counter column only with replication factor ALL, so >> is it mean that we can't read data while any replic

Re: Counter Column

2011-06-27 Thread Donal Zang
On 27/06/2011 17:04, Artem Orobets wrote: Hi! As I know, we use counter column only with replication factor ALL, so is it mean that we can't read data while any replica will fail? you can use any consistency level, using replicate_on_write=true when create the counter column family. -- Do

Re: Counter Column in Cassandra

2011-06-13 Thread Patricio Echagüe
It's a column whose content represents a distributed counter. http://wiki.apache.org/cassandra/Counters On Mon, Jun 13, 2011 at 8:29 AM, Sijie YANG wrote: > Hi, All > > I am newbie to cassandra. I have a simple question but don't find any clear > answer by searching google: > What's the meaning

Re: Counter Column family Cassandra 0.8 PHP Support ?

2011-05-17 Thread aaron morton
I'm not a php type person, but I can help a little with thrift. Install thrift 0.6 and then run this in the interface/ directory of the cassandra source... thrift --gen php cassandra.thrift You should end up with the interface/gen-php/ Hope that helps. - Aaron Morton Freelan