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