incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Brosius <dbros...@mebigfatguy.com>
Subject Re: counter column family
Date Tue, 27 Mar 2012 14:04:46 GMT
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 <robin@us2.nl 
> <mailto:robin@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.agrawal@impetus.co.in
>     <mailto:rishabh.agrawal@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:puneetloya@gmail.com
>         <mailto:puneetloya@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 <robin@us2.nl
>         <mailto:robin@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 <puneetloya@gmail.com
>         <mailto:puneetloya@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>
>
>


Mime
View raw message