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
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
wrote:
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
--
Tyler Hobbs
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.com wrote:
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
SystemManager.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.
Appreciate if someone can help me.
Thanks
1.
http://pycassa.github.io/pycassa/api/pycassa
SystemManager.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.
Appreciate if someone can help me.
Thanks
1.
http://pycassa.github.io/pycassa/api/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
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/
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 can help me.
Thanks
1.
http://pycassa.github.io/pycassa/api/pycassa/system_manager.html
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
--
Tyler Hobbs
DataStax http://datastax.com
On Tue, Apr 16, 2013 at 10:29 PM, Kuldeep Mishra
kuld.cs.mis...@gmail.comwrote:
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
Freelance Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 15/04/2013, at 3:58 PM, Kuldeep Mishra kuld.cs.mis...@gmail.com
wrote:
Hi,
While I creating counter column family a extra column is being added
what I do ?
Table creation script
CREATE
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
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,
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 supposed to type
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 PRIMARY KEY
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
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
Thanks @aaron for the rectification
On Wed, Mar 6, 2013 at 1:17 PM, aaron morton aa...@thelastpickle.comwrote:
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
54 8356490
Fax: +972 2 5612956
On Tue, Apr 17, 2012 at 6:59 PM, Tamar Fraenkel ta...@tok-media.com 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 following counter column
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
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
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
On Tue, Mar 27, 2012 at 9:35 AM, puneet loya puneetl...@gmail.com 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
Can u give an example of create column family with counter column in it.
Please reply
Regards,
Puneet Loya
*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
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
.
*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
) 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
: '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
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
[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,
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
May be the same as https://issues.apache.org/jira/browse/CASSANDRA-3006 ?
On Tue, Aug 16, 2011 at 12:20 PM, Ryan Lowe ryanjl...@gmail.com 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
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
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
36 matches
Mail list logo