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 8356490
Fax:   +972 2 5612956





On Tue, Apr 17, 2012 at 6:59 PM, Tamar Fraenkel ta...@tok-media.com wrote:

 Hi!
 I want to understand how incrementing of counter works.


- I have a 3 node ring,
- I use FailoverPolicy.FAIL_FAST,
- RF is 2,

 I have the following counter column family
 ColumnFamily: tk_counters
   Key Validation Class: org.apache.cassandra.db.marshal.CompositeType(
 org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.
 UUIDType)
   Default column value validator: org.apache.cassandra.db.marshal.
 CounterColumnType
   Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
   Row cache size / save period in seconds / keys to save : 0.0/0/all
   Row Cache Provider: org.apache.cassandra.cache.
 SerializingCacheProvider
   Key cache size / save period in seconds: 0.0/14400
   GC grace seconds: 864000
   Compaction min/max thresholds: 4/32
   Read repair chance: 1.0
   Replicate on write: true
   Bloom Filter FP chance: default
   Built indexes: []
   Compaction Strategy:
 org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy

 My CL for this column family is Write=2, Read=1.

 When I increment a counter (using hector mutator), and execute returns
 without errors, what is the status of the nodes at that stage.
 Can execute return before the nodes are really updated? So that if a read
 is done immediately after the increment it will still read the previous
 values?
 Thanks,

 *Tamar Fraenkel *
 Senior Software Engineer, TOK Media

 [image: Inline image 1]

 ta...@tok-media.com
 Tel:   +972 2 6409736
 Mob:  +972 54 8356490
 Fax:   +972 2 5612956




tokLogo.png

Re: counter column family

2012-04-04 Thread aaron morton
You may have better luck with Hector specific questions on the Hector User 
Group https://groups.google.com/forum/?fromgroups#!forum/hector-users

Cheers
 
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com

On 4/04/2012, at 5:54 PM, Tamar Fraenkel wrote:

 Hi!
 So, if I am using Hector, I need to do:
 cassandraHostConfigurator.setRetryDownedHosts(false)?
 
 How will this affect my application generally?
 
 Thanks
 
 Tamar Fraenkel 
 Senior Software Engineer, TOK Media 
 
 tokLogo.png
 
 ta...@tok-media.com
 Tel:   +972 2 6409736 
 Mob:  +972 54 8356490 
 Fax:   +972 2 5612956 
 
 
 
 
 
 On Tue, Mar 27, 2012 at 4:25 PM, R. Verlangen ro...@us2.nl wrote:
 You should use a connection pool without retries to prevent a single 
 increment of +1 have a result of e.g. +3.
 
 
 2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in
 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 :) :)
 
  
 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 ro...@us2.nl wrote:
 
 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 puneetl...@gmail.com
 
 Can u give an example of create column family with counter column in it. 
 
  
  
 Please reply
 
  
  
 Regards,
 
  
 Puneet Loya
 
 
 
  
 -- 
 With kind regards,
 
  
 Robin Verlangen
 
 www.robinverlangen.nl
 
  
  
 
 
 Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know 
 more about our Big Data quick-start program at the event. 
 
 New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis On-premise’ 
 available at http://bit.ly/z6zT4L. 
 
 
 NOTE: This message may contain information that is confidential, proprietary, 
 privileged or otherwise protected by law. The message is intended solely for 
 the named addressee. If received in error, please destroy and notify the 
 sender. Any use of this email is prohibited when received in error. Impetus 
 does not represent, warrant and/or guarantee, that the integrity of this 
 communication has been maintained nor that the communication is free of 
 errors, virus, interception or interference.
 
 
 
 -- 
 With kind regards,
 
 Robin Verlangen
 www.robinverlangen.nl
 
 



Re: counter column family

2012-04-03 Thread Tamar Fraenkel
Hi!
So, if I am using Hector, I need to do:
cassandraHostConfigurator.setRetryDownedHosts(false)?

How will this affect my application generally?

Thanks

*Tamar Fraenkel *
Senior Software Engineer, TOK Media

[image: Inline image 1]

ta...@tok-media.com
Tel:   +972 2 6409736
Mob:  +972 54 8356490
Fax:   +972 2 5612956





On Tue, Mar 27, 2012 at 4:25 PM, R. Verlangen ro...@us2.nl wrote:

 You should use a connection pool without retries to prevent a single
 increment of +1 have a result of e.g. +3.


 2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in

  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 :) :)



 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 ro...@us2.nl wrote:

 *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 puneetl...@gmail.com

 Can u give an example of create column family with counter column in it.





 Please reply





 Regards,



 Puneet Loya





 --
 With kind regards,



 Robin Verlangen

 www.robinverlangen.nl





 --

 Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22.
 Know more about our Big Data quick-start program at the event.

 New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis
 On-premise’ available at http://bit.ly/z6zT4L.


 NOTE: This message may contain information that is confidential,
 proprietary, privileged or otherwise protected by law. The message is
 intended solely for the named addressee. If received in error, please
 destroy and notify the sender. Any use of this email is prohibited when
 received in error. Impetus does not represent, warrant and/or guarantee,
 that the integrity of this communication has been maintained nor that the
 communication is free of errors, virus, interception or interference.




 --
 With kind regards,

 Robin Verlangen
 www.robinverlangen.nl


tokLogo.png

Re: counter column family

2012-03-29 Thread Tyler Hobbs
On Tue, Mar 27, 2012 at 9:35 AM, puneet loya puneetl...@gmail.com 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 http://datastax.com/


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 puneetl...@gmail.com

 Can u give an example of create column family with counter column in it.


 Please reply


 Regards,

 Puneet Loya




-- 
With kind regards,

Robin Verlangen
www.robinverlangen.nl


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 ro...@us2.nl wrote:

 *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 puneetl...@gmail.com

 Can u give an example of create column family with counter column in it.


 Please reply


 Regards,

 Puneet Loya




 --
 With kind regards,

 Robin Verlangen
 www.robinverlangen.nl




Re: counter column family

2012-03-27 Thread R. Verlangen
You should use a connection pool without retries to prevent a single
increment of +1 have a result of e.g. +3.

2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in

  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 :) :)



 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 ro...@us2.nl wrote:

 *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 puneetl...@gmail.com

 Can u give an example of create column family with counter column in it.





 Please reply





 Regards,



 Puneet Loya





 --
 With kind regards,



 Robin Verlangen

 www.robinverlangen.nl





 --

 Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. Know
 more about our Big Data quick-start program at the event.

 New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis
 On-premise’ available at http://bit.ly/z6zT4L.


 NOTE: This message may contain information that is confidential,
 proprietary, privileged or otherwise protected by law. The message is
 intended solely for the named addressee. If received in error, please
 destroy and notify the sender. Any use of this email is prohibited when
 received in error. Impetus does not represent, warrant and/or guarantee,
 that the integrity of this communication has been maintained nor that the
 communication is free of errors, virus, interception or interference.




-- 
With kind regards,

Robin Verlangen
www.robinverlangen.nl


Re: counter column family

2012-03-27 Thread puneet loya
wen i m using a counter column.. i m nt able to add columns of other type
to the column family.. is it so or it is just synactical error??

[default@CMDCv99] create column family status
... with comparator = AsciiType
... and column_metadata =
... [{
... column_name : Test,
... validation_class : IntegerType,
... index_type : 0,
... index_name : IdxName},
... {
... column_name : 'other name',
... validation_class : CounterColumnType
... }];
Cannot add a counter column (other name) in a non counter column family

On Tue, Mar 27, 2012 at 6:55 PM, R. Verlangen ro...@us2.nl wrote:

 You should use a connection pool without retries to prevent a single
 increment of +1 have a result of e.g. +3.


 2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in

  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 :) :)



 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 ro...@us2.nl wrote:

 *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 puneetl...@gmail.com

 Can u give an example of create column family with counter column in it.





 Please reply





 Regards,



 Puneet Loya





 --
 With kind regards,



 Robin Verlangen

 www.robinverlangen.nl





 --

 Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22.
 Know more about our Big Data quick-start program at the event.

 New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis
 On-premise’ available at http://bit.ly/z6zT4L.


 NOTE: This message may contain information that is confidential,
 proprietary, privileged or otherwise protected by law. The message is
 intended solely for the named addressee. If received in error, please
 destroy and notify the sender. Any use of this email is prohibited when
 received in error. Impetus does not represent, warrant and/or guarantee,
 that the integrity of this communication has been maintained nor that the
 communication is free of errors, virus, interception or interference.




 --
 With kind regards,

 Robin Verlangen
 www.robinverlangen.nl




Re: counter column family

2012-03-27 Thread Dave Brosius

Counter columns are special, they must be in a column family to themselves.

On 03/27/2012 09:32 AM, puneet loya wrote:
wen i m using a counter column.. i m nt able to add columns of other 
type to the column family.. is it so or it is just synactical error??


[default@CMDCv99] create column family status
... with comparator = AsciiType
... and column_metadata =
... [{
... column_name : Test,
... validation_class : IntegerType,
... index_type : 0,
... index_name : IdxName},
... {
... column_name : 'other name',
... validation_class : CounterColumnType
... }];
Cannot add a counter column (other name) in a non counter column family

On Tue, Mar 27, 2012 at 6:55 PM, R. Verlangen ro...@us2.nl 
mailto:ro...@us2.nl wrote:


You should use a connection pool without retries to prevent a
single increment of +1 have a result of e.g. +3.


2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in
mailto:rishabh.agra...@impetus.co.in

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
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 :) :)

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 ro...@us2.nl
mailto:ro...@us2.nl wrote:

*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 puneetl...@gmail.com
mailto:puneetl...@gmail.com

Can u give an example of create column family with counter
column in it.

Please reply

Regards,

Puneet Loya



-- 
With kind regards,


Robin Verlangen

www.robinverlangen.nl http://www.robinverlangen.nl




Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar
21-22. Know more about our Big Data quick-start program at the
event.

New Impetus webcast ‘Cloud-enabled Performance Testing
vis-à-vis On-premise’ available at http://bit.ly/z6zT4L.


NOTE: This message may contain information that is
confidential, proprietary, privileged or otherwise protected
by law. The message is intended solely for the named
addressee. If received in error, please destroy and notify the
sender. Any use of this email is prohibited when received in
error. Impetus does not represent, warrant and/or guarantee,
that the integrity of this communication has been maintained
nor that the communication is free of errors, virus,
interception or interference.




-- 
With kind regards,


Robin Verlangen
www.robinverlangen.nl http://www.robinverlangen.nl






Re: counter column family

2012-03-27 Thread puneet loya
now i want to have a field incrementing with every row insertion. how do i
do it in cassandra??

On Tue, Mar 27, 2012 at 7:34 PM, Dave Brosius dbros...@mebigfatguy.comwrote:

  Counter columns are special, they must be in a column family to
 themselves.

 On 03/27/2012 09:32 AM, puneet loya wrote:

 wen i m using a counter column.. i m nt able to add columns of other type
 to the column family.. is it so or it is just synactical error??

  [default@CMDCv99] create column family status
 ... with comparator = AsciiType
 ... and column_metadata =
 ... [{
 ... column_name : Test,
 ... validation_class : IntegerType,
 ... index_type : 0,
 ... index_name : IdxName},
 ... {
 ... column_name : 'other name',
 ... validation_class : CounterColumnType
 ... }];
 Cannot add a counter column (other name) in a non counter column family

 On Tue, Mar 27, 2012 at 6:55 PM, R. Verlangen ro...@us2.nl wrote:

 You should use a connection pool without retries to prevent a single
 increment of +1 have a result of e.g. +3.


 2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in

  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 :) :)



 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 ro...@us2.nl wrote:

 *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 puneetl...@gmail.com

 Can u give an example of create column family with counter column in it.





 Please reply





 Regards,



 Puneet Loya





 --
 With kind regards,



 Robin Verlangen

 www.robinverlangen.nl





  --

 Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22.
 Know more about our Big Data quick-start program at the event.

 New Impetus webcast ‘Cloud-enabled Performance Testing vis-à-vis
 On-premise’ available at http://bit.ly/z6zT4L.


 NOTE: This message may contain information that is confidential,
 proprietary, privileged or otherwise protected by law. The message is
 intended solely for the named addressee. If received in error, please
 destroy and notify the sender. Any use of this email is prohibited when
 received in error. Impetus does not represent, warrant and/or guarantee,
 that the integrity of this communication has been maintained nor that the
 communication is free of errors, virus, interception or interference.




  --
 With kind regards,

  Robin Verlangen
 www.robinverlangen.nl






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 nodes.

Thanks!
Ryan

On Tue, Aug 16, 2011 at 1:18 PM, Ryan Lowe ryanjl...@gmail.com wrote:

 [default@Race] list CounterCF;
 Using default limit of 100
 ---
 RowKey: Stats
 = (counter=APP, value=7503)
 = (counter=FILEUPLOAD, value=155)
 = (counter=MQUPLOAD, value=4726775)
 = (counter=PAGES, value=131948)
 = (counter=REST, value=3)
 = (counter=SOAP, value=44)
 = (counter=WS, value=1943)

 1 Row Returned.
 [default@Race] list CounterCF;
 Using default limit of 100
 ---
 RowKey: Stats
 = (counter=APP, value=93683)
 = (counter=FILEUPLOAD, value=347)
 = (counter=MQUPLOAD, value=14961065367)
 = (counter=PAGES, value=183089568)
 = (counter=REST, value=3)
 = (counter=SOAP, value=44)
 = (counter=WS, value=23972)

 1 Row Returned.
 [default@Race] list CounterCF;
 Using default limit of 100
 ---
 RowKey: Stats
 = (counter=APP, value=7503)
 = (counter=FILEUPLOAD, value=155)
 = (counter=MQUPLOAD, value=4726775)
 = (counter=PAGES, value=131948)
 = (counter=REST, value=3)
 = (counter=SOAP, value=44)
 = (counter=WS, value=1943)

 1 Row Returned.
 [default@Race] list CounterCF;
 Using default limit of 100
 ---
 RowKey: Stats
 = (counter=APP, value=7503)
 = (counter=FILEUPLOAD, value=155)
 = (counter=MQUPLOAD, value=4726775)
 = (counter=PAGES, value=131948)
 = (counter=REST, value=3)
 = (counter=SOAP, value=44)
 = (counter=WS, value=1943)



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 ryanjl...@gmail.com 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 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 nodes.
 Thanks!
 Ryan

 On Tue, Aug 16, 2011 at 1:18 PM, Ryan Lowe ryanjl...@gmail.com wrote:

 [default@Race] list CounterCF;
 Using default limit of 100
 ---
 RowKey: Stats
 = (counter=APP, value=7503)
 = (counter=FILEUPLOAD, value=155)
 = (counter=MQUPLOAD, value=4726775)
 = (counter=PAGES, value=131948)
 = (counter=REST, value=3)
 = (counter=SOAP, value=44)
 = (counter=WS, value=1943)
 1 Row Returned.
 [default@Race] list CounterCF;
 Using default limit of 100
 ---
 RowKey: Stats
 = (counter=APP, value=93683)
 = (counter=FILEUPLOAD, value=347)
 = (counter=MQUPLOAD, value=14961065367)
 = (counter=PAGES, value=183089568)
 = (counter=REST, value=3)
 = (counter=SOAP, value=44)
 = (counter=WS, value=23972)
 1 Row Returned.
 [default@Race] list CounterCF;
 Using default limit of 100
 ---
 RowKey: Stats
 = (counter=APP, value=7503)
 = (counter=FILEUPLOAD, value=155)
 = (counter=MQUPLOAD, value=4726775)
 = (counter=PAGES, value=131948)
 = (counter=REST, value=3)
 = (counter=SOAP, value=44)
 = (counter=WS, value=1943)
 1 Row Returned.
 [default@Race] list CounterCF;
 Using default limit of 100
 ---
 RowKey: Stats
 = (counter=APP, value=7503)
 = (counter=FILEUPLOAD, value=155)
 = (counter=MQUPLOAD, value=4726775)
 = (counter=PAGES, value=131948)
 = (counter=REST, value=3)
 = (counter=SOAP, value=44)
 = (counter=WS, value=1943)




-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com


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 of sync with each
other with more than a 2 min difference!  I reconfigured ntp and I think I
am back in business.

Thanks though!
Ryan

On Tue, Aug 16, 2011 at 2:53 PM, Jonathan Ellis jbel...@gmail.com wrote:

 May be the same as https://issues.apache.org/jira/browse/CASSANDRA-3006 ?

 On Tue, Aug 16, 2011 at 12:20 PM, Ryan Lowe ryanjl...@gmail.com 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 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 nodes.
  Thanks!
  Ryan
 
  On Tue, Aug 16, 2011 at 1:18 PM, Ryan Lowe ryanjl...@gmail.com wrote:
 
  [default@Race] list CounterCF;
  Using default limit of 100
  ---
  RowKey: Stats
  = (counter=APP, value=7503)
  = (counter=FILEUPLOAD, value=155)
  = (counter=MQUPLOAD, value=4726775)
  = (counter=PAGES, value=131948)
  = (counter=REST, value=3)
  = (counter=SOAP, value=44)
  = (counter=WS, value=1943)
  1 Row Returned.
  [default@Race] list CounterCF;
  Using default limit of 100
  ---
  RowKey: Stats
  = (counter=APP, value=93683)
  = (counter=FILEUPLOAD, value=347)
  = (counter=MQUPLOAD, value=14961065367)
  = (counter=PAGES, value=183089568)
  = (counter=REST, value=3)
  = (counter=SOAP, value=44)
  = (counter=WS, value=23972)
  1 Row Returned.
  [default@Race] list CounterCF;
  Using default limit of 100
  ---
  RowKey: Stats
  = (counter=APP, value=7503)
  = (counter=FILEUPLOAD, value=155)
  = (counter=MQUPLOAD, value=4726775)
  = (counter=PAGES, value=131948)
  = (counter=REST, value=3)
  = (counter=SOAP, value=44)
  = (counter=WS, value=1943)
  1 Row Returned.
  [default@Race] list CounterCF;
  Using default limit of 100
  ---
  RowKey: Stats
  = (counter=APP, value=7503)
  = (counter=FILEUPLOAD, value=155)
  = (counter=MQUPLOAD, value=4726775)
  = (counter=PAGES, value=131948)
  = (counter=REST, value=3)
  = (counter=SOAP, value=44)
  = (counter=WS, value=1943)
 



 --
 Jonathan Ellis
 Project Chair, Apache Cassandra
 co-founder of DataStax, the source for professional Cassandra support
 http://www.datastax.com



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
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com

On 17 May 2011, at 11:26, bhanu choudhary wrote:

 
 I am using counters to read the counts on my website dynamically. I am 
 looking for phpcassandra client(?) that supports counters natively. I was 
 looking if any PHP developer could give me a lead in generating the PHP 
 client code required using thrift.
 
 Thanks in advance!