Re: Reading the write time of each value in a set?

2014-11-14 Thread DuyHai Doan
Why don't you use map to store write time as value and data as key? Le 15 nov. 2014 00:24, "Kevin Burton" a écrit : > I’m trying to build a histograph in CQL for various records. I’d like to > keep a max of ten items or items with a TTL. but if there are too many > items, I’d like to trim it so

RE: Questiona about node repair

2014-11-14 Thread Di, Jieming
Thanks DuyHai. From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: 2014年11月14日 21:55 To: user@cassandra.apache.org Subject: Re: Questiona about node repair By checking into the source code: StorageService: public void forceTerminateAllRepairSessions() { ActiveRepairService.instance

RE: Questiona about node repair

2014-11-14 Thread Di, Jieming
Thanks Rob. From: Robert Coli [mailto:rc...@eventbrite.com] Sent: 2014年11月15日 2:50 To: user@cassandra.apache.org Subject: Re: Questiona about node repair On Thu, Nov 13, 2014 at 7:01 PM, Di, Jieming mailto:jieming...@emc.com>> wrote I have a question about Cassandra node repair, there is a fun

Re: Cassandra default consistency level on multi datacenter

2014-11-14 Thread Tyler Hobbs
Cassandra itself does not have default consistency levels. These are only configured in the driver. On Fri, Nov 14, 2014 at 8:54 AM, Adil wrote: > Hi, > We are using two datacenter and we want to set the default consistency > level to LOCAL_ONE instead of ONE but we don't know how to configure

Re: Which JMX item can I use to see total cluster (or data center) Read and Write volumes?

2014-11-14 Thread Tyler Hobbs
OpsCenter is aggregating individual metrics across the whole datacenter (or cluster). The individual metrics are in org.apache.cassandra.metrics.ClientRequest.Read.Latency.count and Write.Latency.count. On Fri, Nov 14, 2014 at 10:04 AM, Bob Nilsen wrote: > Hi all, > > Within DataStax OpsCenter

Re: Working with legacy data via CQL

2014-11-14 Thread Tyler Hobbs
What version of cassandra did you originally create the column family in? Have you made any schema changes to it through cql or cassandra-cli, or has it always been exactly the same? On Wed, Nov 12, 2014 at 2:06 AM, Erik Forsberg wrote: > On 2014-11-11 19:40, Alex Popescu wrote: > > On Tuesday,

Reading the write time of each value in a set?

2014-11-14 Thread Kevin Burton
I’m trying to build a histograph in CQL for various records. I’d like to keep a max of ten items or items with a TTL. but if there are too many items, I’d like to trim it so the max number of records is about 20. So if I exceed 20, I need to removed the oldest records. I’m using a set append so

Re: Questiona about node repair

2014-11-14 Thread Robert Coli
On Thu, Nov 13, 2014 at 7:01 PM, Di, Jieming wrote > I have a question about Cassandra node repair, there is a function called > “forceTerminateAllRepairSessions();”, so will the function terminate all > the repair session in only one node, or it will terminate all the session > in a ring? And wh

Re: Repair completes successfully but data is still inconsistent

2014-11-14 Thread André Cruz
On 14 Nov 2014, at 18:29, Michael Shuler wrote: > > On 11/14/2014 12:12 PM, André Cruz wrote: >> Some extra info. I checked the backups and on the 8th of November, all 3 >> replicas had the tombstone of the deleted column. So: >> >> 1 November - column is deleted - gc_grace_period is 10 days >>

Re: Repair completes successfully but data is still inconsistent

2014-11-14 Thread Michael Shuler
On 11/14/2014 12:12 PM, André Cruz wrote: Some extra info. I checked the backups and on the 8th of November, all 3 replicas had the tombstone of the deleted column. So: 1 November - column is deleted - gc_grace_period is 10 days 8 November - all 3 replicas have tombstone 13/14 November - column

Re: Repair completes successfully but data is still inconsistent

2014-11-14 Thread André Cruz
Some extra info. I checked the backups and on the 8th of November, all 3 replicas had the tombstone of the deleted column. So: 1 November - column is deleted - gc_grace_period is 10 days 8 November - all 3 replicas have tombstone 13/14 November - column/tombstone is gone on 2 replicas, 3rd replic

Repair completes successfully but data is still inconsistent

2014-11-14 Thread André Cruz
Hello. So, I have detected a data inconsistency between my nodes: (Consistency level is ONE) [disco@Disco] get NamespaceFile2['45fc8996-41bc-429b-a382-5da9294eb59c:/XXXDIRXXX']['XXXFILEXXX']; Value was not found Elapsed time: 48 msec(s). [disco@Disco] get NamespaceFile2['45fc8996-41bc-429b-a382

Which JMX item can I use to see total cluster (or data center) Read and Write volumes?

2014-11-14 Thread Bob Nilsen
Hi all, Within DataStax OpsCenter I can see metrics that show total traffic volume for a cluster and each data center. How can I find these same numbers amongst all the JMX items? Thanks, -- Bob Nilsen rwnils...@gmail.com

Cassandra default consistency level on multi datacenter

2014-11-14 Thread Adil
Hi, We are using two datacenter and we want to set the default consistency level to LOCAL_ONE instead of ONE but we don't know how to configure it. We set LOCAL_QUORUM via cql driver for the desired queries but we won't do the same for the default one. Thanks in advance Adil

Re: Cassandra communication between 2 datacenter

2014-11-14 Thread Adil
Thank you Eric, the problem in fact was that the ports were open only in one sense. now is working. 2014-11-13 22:38 GMT+01:00 Eric Plowe : > Are you sure that both DC's can communicate with each other over the > necessary ports? > > On Thu, Nov 13, 2014 at 3:46 PM, Adil wrote: > >> yeh we start

Re: Questiona about node repair

2014-11-14 Thread DuyHai Doan
By checking into the source code: StorageService: public void forceTerminateAllRepairSessions() { ActiveRepairService.instance.terminateSessions(); } ActiveRepairService: public void terminateSessions() { for (RepairSession session : sessions.values()) {

Re: about collections limit

2014-11-14 Thread DuyHai Doan
No, collections and map are fetched entirely server side and returned to the client. Updates & deletes can be done on elements though On Fri, Nov 14, 2014 at 7:47 AM, diwayou wrote: > can i scan collection (list, set) paged by limit? >