cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From puneet loya <puneetl...@gmail.com>
Subject Re: counter column family
Date Tue, 27 Mar 2012 14:35:07 GMT
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 <dbrosius@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 <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>
>>
>>>  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]
>>> *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 <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>
>>>
>>> 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
>>
>>
>
>

Mime
View raw message