Re: Cassandra counter column family performance

> I get a lot of TExceptions What are the exceptions ? In general counters are slower than writes, but that does not lead them to fail like that. Check the logs for errors and/or messages from the GCInspector saying the garbage collection is going on. Cheers A - Aaron Morton

Cassandra counter column family performance

Hello all, I have a counter CF defined as pk text PRIMARY KEY, a counter, b counter, c counter, d counter After inserting a few million keys... 55 mil, the performance goes down the drain, 2-3 nodes in the cluster are on medium load, and when inserting batches of same lengths writes take longer

Re: How to create counter column family via Pycassa?

gt;>> >>>> >>>> On Thu, Aug 15, 2013 at 12:30 PM, Tyler Hobbs wrote: >>>> >>>>> The column_validation_classes arg is just for defining individual >>>>> column types. Glad you got it figured out, though. >>>>> >>>>

Re: How to create counter column family via Pycassa?

t;>> nishant.has.a.quest...@gmail.com> wrote: >>>> >>>>> Thanks for quick reply. Apparantly, I was trying this to get working >>>>> >>>>> cf_kwargs = {'default_validation_class':COUNTER_COLUMN_TYPE} >>>>> sys.creat

Re: How to create counter column family via Pycassa?

ply. Apparantly, I was trying this to get working >>>> >>>> cf_kwargs = {'default_validation_class':COUNTER_COLUMN_TYPE} >>>> sys.create_column_family('my_ks', 'vote_count', >>>> column_validation_classes=cf_kwargs) #1 >>>

Re: How to create counter column family via Pycassa?

his works: >>> >>> sys.create_column_family('my_ks', 'vote_count', **cf_kwargs) #2 >>> >>> I thought #1 should work. >>> >>> >>> >>> On Thu, Aug 15, 2013 at 9:15 PM, Tyler Hobbs wrote: >>> >>>> Th

Re: How to create counter column family via Pycassa?

F a counter CF is that the default >>> validation class is CounterColumnType, which you can set through >>> SystemManager.create_column_family(). >>> >>> >>> On Thu, Aug 15, 2013 at 10:38 AM, Pinak Pani < >>> nishant.has.a.quest...@gmail.c

Re: How to create counter column family via Pycassa?

create_column_family(). >> >> >> On Thu, Aug 15, 2013 at 10:38 AM, Pinak Pani < >> nishant.has.a.quest...@gmail.com> wrote: >> >>> I do not find a way to create a counter column family in Pycassa. >>> This[1] does not help. >>> >>

Re: How to create counter column family via Pycassa?

ate_column_family(). > > > On Thu, Aug 15, 2013 at 10:38 AM, Pinak Pani < > nishant.has.a.quest...@gmail.com> wrote: > >> I do not find a way to create a counter column family in Pycassa. >> This[1] does not help. >> >> Appreciate if someone

Re: How to create counter column family via Pycassa?

create a counter column family in Pycassa. > This[1] does not help. > > Appreciate if someone can help me. > > Thanks > > 1. > http://pycassa.github.io/pycassa/api/pycassa/system_manager.html#pycassa.system_manager.SystemManager.create_column_family > -- Tyler Hobbs DataStax <http://datastax.com/>

How to create counter column family via Pycassa?

I do not find a way to create a counter column family in Pycassa. This[1] does not help. Appreciate if someone can help me. Thanks 1. http://pycassa.github.io/pycassa/api/pycassa/system_manager.html#pycassa.system_manager.SystemManager.create_column_family

Re: Added extra column as composite key while creation counter column family

On Tue, Apr 16, 2013 at 10:29 PM, Kuldeep Mishra wrote: > cassandra 1.2.0 > > Is it a bug in 1.2.0 ? > While I can't speak to this specific issue, 1.2.0 has meaningful known issues. I suggest upgrade to 1.2.3(/4) ASAP. =Rob

Re: Added extra column as composite key while creation counter column family

={'class': 'SizeTieredCompactionStrategy'} AND > compression={'sstable_compression': 'SnappyCompressor'}; > > Cheers > > - > Aaron Morton > Freelance Cassandra Consultant > New Zealand > > @aaronmorton > http://www.thelastpickle.com &g

Re: Added extra column as composite key while creation counter column family

http://www.thelastpickle.com On 15/04/2013, at 3:58 PM, Kuldeep Mishra wrote: > Hi, >While I creating counter column family a extra column is being added what > I do ? > Table creation script > CREATE TABLE counters ( > key text, > value counter, > PRIMARY KEY (key)

Added extra column as composite key while creation counter column family

Hi, While I creating counter column family a extra column is being added what I do ? Table creation script CREATE TABLE counters ( key text, value counter, PRIMARY KEY (key) ) WITH COMPACT STORAGE after describing column family I am getting following CREATE TABLE counters ( key text

Re: Can I create a counter column family with many rows in 1.1.10?

If you have one column in the table that is not part of the primary key and is a counter, then all columns that are not part of the primary key must also be a counter. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On

RE: Can I create a counter column family with many rows in 1.1.10?

I got it now. From: mateus.ffrei...@hotmail.com To: user@cassandra.apache.org Subject: RE: Can I create a counter column family with many rows in 1.1.10? Date: Wed, 6 Mar 2013 08:42:37 -0300 Ah, I'ts with many columns, not rows. I use this in cql 2-3 create table cnt (key text PRIMAR

RE: Can I create a counter column family with many rows in 1.1.10?

Ah, I'ts with many columns, not rows. I use this in cql 2-3 create table cnt (key text PRIMARY KEY, y2003 counter, y2004 counter);it says this is not a counter column family, and if I try to use default_validation_class=CounterType,it says this is not a valid keyword.What I'm suppos

Re: Can I create a counter column family with many rows in 1.1.10?

What would be the exact CQL3 syntax to create a counter CF with composite row key and not predefined column names ? Is the following supposed to work ? CREATE TABLE composite_counter ( aid text, key1 text, key2 text, key3 text, value counter, PRIMARY

Re: Can I create a counter column family with many rows in 1.1.10?

Thanks @aaron for the rectification On Wed, Mar 6, 2013 at 1:17 PM, aaron morton wrote: > Note that CQL 3 in 1.1 is compatible with CQL 3 in 1.2. Also you do not > have to use CQL 3, you can still use the cassandra-cli to create CF's. > > The syntax you use to populate it depends on the client

Re: Can I create a counter column family with many rows in 1.1.10?

Note that CQL 3 in 1.1 is compatible with CQL 3 in 1.2. Also you do not have to use CQL 3, you can still use the cassandra-cli to create CF's. The syntax you use to populate it depends on the client you are using. Cheers - Aaron Morton Freelance Cassandra Developer New Zeala

Re: Can I create a counter column family with many rows in 1.1.10?

Yes you can , you just have to use CQL3 and 1.1.10 onward cassandra supports CQL3. Just you have to aware of the fact that a column family that contains a counter column can only contain counters. In other other words either all the columns of the column family excluding KEY have the counter type

Can I create a counter column family with many rows in 1.1.10?

And what syntax would be, if it's possible?Thanks.

Re: Counter column family

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 foll

Counter column family

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

Re: counter column family

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 >

Re: counter column family

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

Re: counter column family

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

: 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

Re: counter column family

: '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 r

Re: counter column family

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

Re: counter column family

gt; > *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 

RE: counter column family

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

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:

RE: counter column family

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 c

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

counter column family

Can u give an example of create column family with counter column in it. Please reply Regards, Puneet Loya

Re: Counter Column Family Inconsistent Node

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

Re: Counter Column Family Inconsistent Node

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

Re: Counter Column Family Inconsistent Node

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

Counter Column Family Inconsistent Node

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

Re: Counter Column family Cassandra 0.8 PHP Support ?

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 Freelan

Counter Column family Cassandra 0.8 PHP Support ?

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!