Re: counter column family

[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 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

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

Re: counter column family

[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 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 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

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

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

Re: counter column family

[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 

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

[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  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 
>
>>  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  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 
>>
>> 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

[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 <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 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 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 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

[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 wrote:

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

[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

[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  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 
>
>>  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  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 
>>
>> 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

[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 
> 
> 
> 
> 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  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 
> 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  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 
> 
> 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

[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  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
>
>
>
>
<>

Re: Counter Column Family Inconsistent Node

[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  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

[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 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  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

[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  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  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  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 ?

[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!