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