Re: Lots of replicate on write tasks pending, want to investigate

The write path (not replicate on write) for counters involves a read, I'm afraid you got it wrong. The read done during counter writes *is* done by the replicate on write taks. Though really, the replicate on write taks are just one part of the counter write path (they are not not the write

What is best Cassandra client?

Hi All, What is the best client to use? I want to use CQL 3.0.3 and have support for preparedStatmements. I tried JDBC and the thrift client so far.   Thanks!

Re: What is best Cassandra client?

Datastax Java driver: https://github.com/datastax/java-driver T# On Thu, Jul 4, 2013 at 10:25 AM, Tony Anecito adanec...@yahoo.com wrote: Hi All, What is the best client to use? I want to use CQL 3.0.3 and have support for preparedStatmements. I tried JDBC and the thrift client so far.

Re: What is best Cassandra client?

Datastax driver for me as well. Sent from my iPhone On 4 Jul 2013, at 09:34, Theo Hultberg t...@iconara.net wrote: Datastax Java driver: https://github.com/datastax/java-driver T# On Thu, Jul 4, 2013 at 10:25 AM, Tony Anecito adanec...@yahoo.com wrote: Hi All, What is the best

going down from RF=3 to RF=2, repair constantly falls over with JVM OOM

Hi, We've made the mistake of letting our nodes get too large, now holding about 3TB each. We ran out of enough free space to have a successful compaction, and because we're on 1.0.7, enabling compression to get out of the mess wasn't feasible. We tried adding another node, but we think this may

Re: going down from RF=3 to RF=2, repair constantly falls over with JVM OOM

I don't think you need to run repair if you decrease RF. At least I wouldn't do it. In case of *decreasing* RF have 3 nodes containing some data, but only 2 of them should store them from now on, so you should rather run cleanup, instead of repair, toget rid of the data on 3rd replica. And I

Partitioner type

Hi, Is it possible to know, type of partitioner programmitcally at runtime? -Vivek

Re: Partitioner type

Yeah its possible, It depends on which client you're using. e,g. In pycassa(python client for cassandra), I use import pycassa from pycassa.system_manager import * sys = SystemManager('hostname:portnumber') sys.describe_partitioner() On Thu, Jul 4, 2013 at 5:32 PM, Vivek Mishra

Re: Partitioner type

yes, you can query local CF in system keyspace: select partitioner from system.local; H On 4 July 2013 13:02, Vivek Mishra mishra.v...@gmail.com wrote: Hi, Is it possible to know, type of partitioner programmitcally at runtime? -Vivek

Re: Partitioner type

Just saw , thrift apis describe_paritioner() method. Thanks for quick suggestions. -Vivek On Thu, Jul 4, 2013 at 5:40 PM, Haithem Jarraya haithem.jarr...@struq.comwrote: yes, you can query local CF in system keyspace: select partitioner from system.local; H On 4 July 2013 13:02,

Re: going down from RF=3 to RF=2, repair constantly falls over with JVM OOM

@Michal: all true, a clean up would certainly remove a lot of useless data there, and I also advice Evan to do it. However, Evan may want to continue repairing his cluster as a routine operation an there is no reason a RF change shouldn't lead to this kind of issues. @Evan : With this amount of

Restart node = hinted handoff flood

Hi, Using C*1.2.2 12 EC2 xLarge cluster. When I restart a node, if it spend a few minutes down, when I bring it up, all the cpu are blocked at 100%, even once compactions are disabled, inducing a very big and intolerable latency in my app. I suspect Hinted Handoff to be the cause of this.

Re: What is best Cassandra client?

Where can I get a compiled jar? I found out about this yesterday but do not have environment setup to compile it.   Thanks! From: Theo Hultberg t...@iconara.net To: user@cassandra.apache.org; Tony Anecito adanec...@yahoo.com Sent: Thursday, July 4, 2013 2:34 AM Subject: Re: What is best

Re: What is best Cassandra client?

2013/7/4 Tony Anecito adanec...@yahoo.com Where can I get a compiled jar? http://search.maven.org/#search%7Cga%7C1%7Ca%3A%22cassandra-driver-core%22 -- MK http://github.com/michaelklishin http://twitter.com/michaelklishin

Re: What is best Cassandra client?

Thanks I found the jar in the maven repository.   -Tony From: Theo Hultberg t...@iconara.net To: user@cassandra.apache.org; Tony Anecito adanec...@yahoo.com Sent: Thursday, July 4, 2013 2:34 AM Subject: Re: What is best Cassandra client? Datastax Java driver: 

Re: Restart node = hinted handoff flood

The point is that there is no way, afaik, to limit the speed of these Hinted Handoff since it's not a stream like repair or bootstrap, no way either to keep the node out of the ring during the time it is receiving hints since hints and normal traffic both go through gossip protocol on port 7000.

Migrating data from 2 node cluster to a 3 node cluster

We are planning to move data from a 2 node cluster to a 3 node cluster. We are planning to copy the data from the two nodes (snapshot) to the new 2 nodes and hoping that Cassandra will sync it to the third node. Will this work ? are there any other commands to run after we are done migrating, like

videos of 2013 summit

Hi, Are the videos online anywhere for the 2013 summit?

Re: videos of 2013 summit

http://www.youtube.com/playlist?list=PLqcm6qE9lgKJzVvwHprow9h7KMpb5hcUU Thanks Jabbar Azam On 4 Jul 2013 18:17, S Ahmed sahmed1...@gmail.com wrote: Hi, Are the videos online anywhere for the 2013 summit?

Re: Migrating data from 2 node cluster to a 3 node cluster

You should run a nodetool repair after you copy the data over. You could also use the sstable loader, which would stream the data to the proper node. On Thu, Jul 4, 2013 at 10:03 AM, srmore comom...@gmail.com wrote: We are planning to move data from a 2 node cluster to a 3 node cluster. We

Re:videos of 2013 summit

http://www.planetcassandra.org/blog/post/cassandra-summit-2013---use-cases-and-technical-presentations

CQL and IN

Hi All,   I am using the DataStax driver and got prepared to work. When I tried to use the IN keyword with a SQL it did not work. According to DataStax IN should work.   So if I tried:   Select * from items Where item_id IN (Select item_id FROM users where user_id = ?)     Thanks for the

Re: CQL and IN

CQL does not support sub-queries. On 4 July 2013 22:53, Tony Anecito adanec...@yahoo.com wrote: Hi All, I am using the DataStax driver and got prepared to work. When I tried to use the IN keyword with a SQL it did not work. According to DataStax IN should work. So if I tried: Select *

Re: CQL and IN

You can use the actual item_ids however, Select * from items Where item_id IN (1, 2, 3, ..., n) On 4 July 2013 23:16, Rui Vieira ruidevie...@googlemail.com wrote: CQL does not support sub-queries. On 4 July 2013 22:53, Tony Anecito adanec...@yahoo.com wrote: Hi All, I am using the

Installing specific version

Hi all Can anyone point me in the right direction for installing a specific version from datastax repo, we need 1.2.4 to keep consistent with our qa environment. It's for a new prod cluster , on Debian 6. I thought it may be a value in /etc/apt/source.list ? The latest 1.2.6 does not appear

How to build indexes?

Hi All, I updated a table with a secondary index. I discovered using CLI describe that the index was not built. How do I build an index after I have altered an existing table with data? I looked at nodetool and cli and saw no command that had the word build index associated with it. And most