Hi,
Recently, I've added a new counter column (let's call it A) to a counter
table, C*3.11.4
I've had to remove it thereafter, because of an application issue.
Later, the recreation was needed.
When I've executed the ADD command again, got an error for recreating
counter column, so I've created
Hi All,
is static column thread safe or only counter column is thread safe?
Thanks!
t;>
>> Probably: https://docs.oracle.com/javase/8/docs/api/java/
>> lang/Long.html#MAX_VALUE
>>
>> On Sun, Oct 23, 2016 at 1:12 PM, Kant Kodali <k...@peernova.com> wrote:
>>
>> What is the maximum value of Cassandra Counter Column?
>>
>>
>>
>>
; wrote:
>
> Probably:
> https://docs.oracle.com/javase/8/docs/api/java/lang/Long.html#MAX_VALUE
>
> On Sun, Oct 23, 2016 at 1:12 PM, Kant Kodali <k...@peernova.com> wrote:
>
> What is the maximum value of Cassandra Counter Column?
>
>
>
>
avase/8/docs/api/java/lan
>> g/Long.html#MAX_VALUE
>>
>> On Sun, Oct 23, 2016 at 1:12 PM, Kant Kodali <k...@peernova.com> wrote:
>>
>>> What is the maximum value of Cassandra Counter Column?
>>>
>>
>>
>
com> wrote:
>
>> What is the maximum value of Cassandra Counter Column?
>>
>
>
Probably:
https://docs.oracle.com/javase/8/docs/api/java/lang/Long.html#MAX_VALUE
On Sun, Oct 23, 2016 at 1:12 PM, Kant Kodali <k...@peernova.com> wrote:
> What is the maximum value of Cassandra Counter Column?
>
What is the maximum value of Cassandra Counter Column?
On 10/13/2016 08:11 PM, Alexei Levashov wrote:
> Previously I did it in a logged batch without any issues but upgrading
> from Cassandra 1.2.x to 2.1 brings the following Exception message:
> "Error executing batch. Message: Cannot include a counter statement in a
> logged batch"
>
> Question:
>
Configuration : Cassandra 2.1
(if it matters Datastax Java driver 3.0.0 - driver users list couldn't help)
Platform Unix.
I have two tables:
CREATE TABLE unmapped_doc_type (
application_id uuid,
doc_type_id text,
metadata text,
PRIMARY KEY (application_id, doc_type_id)
)
CREATE TABLE
necessary to convert it to local time.
On Fri, Dec 26, 2014 at 2:05 AM, Ajay ajay.ga...@gmail.com wrote:
Hi,
If the nodes of Cassandra ring are in different timezone, could it affect
the counter column as it depends on the timestamp?
Thanks
Ajay
the
timestamp as, this is the information necessary to convert it to local time.
On Fri, Dec 26, 2014 at 2:05 AM, Ajay ajay.ga...@gmail.com wrote:
Hi,
If the nodes of Cassandra ring are in different timezone, could it
affect the counter column as it depends on the timestamp?
Thanks
Ajay
it to local time.
On Fri, Dec 26, 2014 at 2:05 AM, Ajay ajay.ga...@gmail.com wrote:
Hi,
If the nodes of Cassandra ring are in different timezone, could it
affect the counter column as it depends on the timestamp?
Thanks
Ajay
--
Thanks,
Phil Yang
--
Thanks,
Phil Yang
,
If the nodes of Cassandra ring are in different timezone, could it
affect the counter column as it depends on the timestamp?
Thanks
Ajay
--
Thanks,
Phil Yang
--
Thanks,
Phil Yang
Hi,
If the nodes of Cassandra ring are in different timezone, could it affect
the counter column as it depends on the timestamp?
Thanks
Ajay
as, this is the
information necessary to convert it to local time.
On Fri, Dec 26, 2014 at 2:05 AM, Ajay ajay.ga...@gmail.com wrote:
Hi,
If the nodes of Cassandra ring are in different timezone, could it affect
the counter column as it depends on the timestamp?
Thanks
Ajay
I was wondering if there is plan to allow creating counter column and
standard column in the same table.
Here is my use case:
I want to use counter to count how many users like a given item in my
application. The like count needs to be returned along with details of item
in query. To support
was wondering if there is plan to allow creating counter column and
standard column in the same table.
Here is my use case:
I want to use counter to count how many users like a given item in my
application. The like count needs to be returned along with details of item
in query. To support querying
You can cheat it by using the non counter column as part of your primary
key (clustering column specifically) but the cases where this could work
are limited and the places this is a good idea are even more rare.
As for using counters in batches are already a not well regarded concept
and counter
in different queries) I don't need a 100% accurate count
and strong consistency. Performance and application complexity is my main
concern.
Thanks
On Mon, Dec 22, 2014 at 10:37 PM, Ryan Svihla rsvi...@datastax.com wrote:
You can cheat it by using the non counter column as part of your primary
key
) I don't need a 100% accurate count
and strong consistency. Performance and application complexity is my main
concern.
Thanks
On Mon, Dec 22, 2014 at 10:37 PM, Ryan Svihla rsvi...@datastax.com
wrote:
You can cheat it by using the non counter column as part of your primary
key (clustering
is my
main concern.
Thanks
On Mon, Dec 22, 2014 at 10:37 PM, Ryan Svihla rsvi...@datastax.com
wrote:
You can cheat it by using the non counter column as part of your primary
key (clustering column specifically) but the cases where this could work
are limited and the places this is a good
and application complexity is my
main concern.
Thanks
On Mon, Dec 22, 2014 at 10:37 PM, Ryan Svihla rsvi...@datastax.com
wrote:
You can cheat it by using the non counter column as part of your
primary key (clustering column specifically) but the cases where this could
work are limited
Hello Clément
This is a known anti-pattern. You should never re-use a deleted counter
column otherwise there will be unpredictable result for the counter value.
Le 6 nov. 2014 08:45, Clément Fumey clement@gmail.com a écrit :
Hi,
I have a table with counter column . When I insert (update
Hi,
I have a table with counter column . When I insert (update) a row, delete
it and try to re-insert, it fail to re-insert the row. Here is the commands
i use :
CREATE TABLE test(
testId int,
year int,
testCounter counter,
PRIMARY KEY (testId, year)
)WITH CLUSTERING ORDER
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
would run a
reconciliation on the underlying data in the column family and compare
this with the counter values. Obviously you can only do this once a
counter column has gone cold - i.e. it wouldn't make sense to
reconcile something that could still get incremented.
Does it make sense to put the insert
the insert
and hope for the best. Then at some later point, we would run a
reconciliation on the underlying data in the column family and compare
this with the counter values. Obviously you can only do this once a
counter column has gone cold - i.e. it wouldn't make sense to
reconcile something that could
for the best. Then at some later point, we would run a
reconciliation on the underlying data in the column family and compare
this with the counter values. Obviously you can only do this once a
counter column has gone cold - i.e. it wouldn't make sense to
reconcile something that could still get
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
The only thing that makes a CF 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.com wrote:
I do not find a way to create a counter
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
it's just a standard get_slice call, the ColumnOrSuperColumn result has either
Column, SuperColumn, CounterColumn or SuperCounterColumn set.
Cheers
-
Aaron Morton
Freelance Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 18/03/2013, at 2:09 AM,
I created a CounterColumnType column family .
create column family counter1 with
default_validation_class=CounterColumnType and replicate_on_write=true;
Unfortunately I could not figure out a way to read the column value. I am
using the Thrift API , and I couldn't make out any sense. I can't
...@gmail.com
wrote:
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
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
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 or none
of them can have it.
Best Regards,
--
Abhijit Chanda
+91-974395
--
Abhijit Chanda
+91-974395
Zealand
@aaronmorton
http://www.thelastpickle.com
On 5/03/2013, at 9:16 PM, Abhijit Chanda abhijit.chan...@gmail.com wrote:
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
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 or none of them can have it.
Best Regards
Thanks Aaron, so will there only be one value for each counter column per
sstable just like regular columns?
Yes.
For some reason I was under the impression that Cassandra keeps a log of all
the increments not the actual value.
Not as far as I understand.
Cheers
Hey Guys,
Are there any specific operational considerations one should make when using
counter columns families? How are counter column families stored on disk? How
do they effect compaction?
-- Drew
Are there any specific operational considerations one should make when using
counter columns families?
Performance, as they incur a read and a write.
There were some issues with overcounts in log replay (see the changes.txt).
How are counter column families stored on disk?
Same
Thanks Aaron, so will there only be one value for each counter column per
sstable just like regular columns? For some reason I was under the impression
that Cassandra keeps a log of all the increments not the actual value.
On Feb 5, 2013, at 12:36 PM, aaron morton aa...@thelastpickle.com wrote
On Mon, Nov 12, 2012 at 3:35 PM, cem cayiro...@gmail.com wrote:
We are currently facing a performance issue with counter column families. I
see lots of pending ReplicateOnWriteStage tasks in tpstats. Then I disabled
replicate_on_write. It helped a lot. I want to use like that but I am
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
I have encountered the following piece of information regarding the use of
‘Counter Column’ in Cassandra: “If a write fails unexpectedly (timeout or
loss of connection to the coordinator node) the client will not know if the
operation has been performed. A retry can result in an over count
On Tue, Apr 3, 2012 at 9:11 AM, Avi-h avih...@gmail.com wrote:
I have encountered the following piece of information regarding the use of
‘Counter Column’ in Cassandra: “If a write fails unexpectedly (timeout or
loss of connection to the coordinator node) the client will not know
?
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Counter-Column-tp7432010p7432450.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive at
Nabble.com.
is for 0.8 beta 1, is it also relevant for 1.0.8?
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Counter-Column-tp7432010p7432450.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive
at Nabble.com.
: Counter Column
this bug is for 0.8 beta 1, is it also relevant for 1.0.8?
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Counter-Column-tp7432010p7432450.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive
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
...@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
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
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
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
:
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
[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
On 27/06/2011 19:19, Sylvain Lebresne wrote:
Let me make that simpler.
Don't ever use replicate_on_write=false (even if you think that it is
what you want, there is a good chance it's not).
Obviously, the default is replicate_on_write=true.
I may be wrong. But with 0.8.0, I think the default is
On Tue, Jun 28, 2011 at 12:53 PM, Donal Zang zan...@ihep.ac.cn wrote:
On 27/06/2011 19:19, Sylvain Lebresne wrote:
Let me make that simpler.
Don't ever use replicate_on_write=false (even if you think that it is
what you want, there is a good chance it's not).
Obviously, the default is
On 27/06/2011 17:04, Artem Orobets wrote:
Hi!
As I know, we use counter column only with replication factor ALL, so
is it mean that we can't read data while any replica will fail?
you can use any consistency level, using replicate_on_write=true when
create the counter column family
if i write at ALL and read at ONE,is that setting required ?
thanks
Le 27 juin 2011 17:22, Donal Zang zan...@ihep.ac.cn a écrit :
On 27/06/2011 17:04, Artem Orobets wrote:
Hi!
As I know, we use counter column only with replication factor ALL, so
is it mean that we can't read data while any
and read at ONE,is that setting required ?
thanks
Le 27 juin 2011 17:22, Donal Zang zan...@ihep.ac.cn a écrit :
On 27/06/2011 17:04, Artem Orobets wrote:
Hi!
As I know, we use counter column only with replication factor ALL, so
is it mean that we can't read data while any replica will fail
Hi, All
I am newbie to cassandra. I have a simple question but don't find any clear
answer by searching google:
What's the meaning of counter column in Cassandra?
Best
:
What's the meaning of counter column in Cassandra?
Best
behavior with deletes + counter, can we redefine the behavior of
counter deletes, so that we can always guarantee the declared behavior? ---
specifically:
*we define that once a counter column is deleted, you can never add to it
again.* attempts to add to a dead counter throws an exception all
errata:
so c(123) means a counter column of ttl=1, so c(123) means a
counter column of ttl=123,
On Sun, May 29, 2011 at 12:24 AM, Yang tedd...@gmail.com wrote:
sorry to beat on the dead horse.
I looked at the link referred from #2103 :
https://issues.apache.org/jira/browse
that once a counter column is deleted, you can never add to it
again.* attempts to add to a dead counter throws an exception all
future adds are just ignored. i.e. a counter column has only one life,
until all tombstones are purged from system, after which it is possible for
the counter
achieve
predictable behavior with deletes + counter, can we redefine the behavior of
counter deletes, so that we can always guarantee the declared behavior? ---
specifically:
we define that once a counter column is deleted, you can never add to it
again. attempts to add to a dead counter
are not commutative. since by definition we can't achieve
predictable behavior with deletes + counter, can we redefine the behavior
of counter deletes, so that we can always guarantee the declared behavior?
--- specifically:
*we define that once a counter column is deleted, you can never add
define that once a counter column is deleted, you can never add to it
again. attempts to add to a dead counter throws an exception all
future adds are just ignored. i.e. a counter column has only one life,
until all tombstones are purged from system, after which it is possible
How about implementing a freezing mechanism on counter columns.
If there are no more increments within freeze seconds after the last
increments (it would be orders or day or so); the column would lock itself
on increments and won't accept increment.
And after this freeze perioid, the ttl should
is this combination feature available , or on track ?
thanks
Yang
No. See comments to https://issues.apache.org/jira/browse/CASSANDRA-2103
On Fri, May 27, 2011 at 7:29 PM, Yang tedd...@gmail.com wrote:
is this combination feature available , or on track ?
thanks
Yang
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the
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
92 matches
Mail list logo