Re: Restart node => hinted handoff flood

My blind guess is: https://issues.apache.org/jira/browse/CASSANDRA-5179 In our case the only sensible solution was to pause hints delivery and disable storing them (both done with a nodetool: pausehandoff and disablehandoff). Once they TTL'd (3 hours by default I believe?) I turned HH on again

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 o

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 co

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 wrote: > CQL does not support sub-queries. > > > On 4 July 2013 22:53, Tony Anecito wrote: > >> Hi All, >> >> I am using the DataStax driver and got prepared to wor

Re: CQL and IN

CQL does not support sub-queries. On 4 July 2013 22:53, Tony Anecito 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 * from item

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 feedb

Re:videos of 2013 summit

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

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 wrote: > We are planning to move data from a 2 node cluster to a 3 node cluster. We > are planning to co

Re: videos of 2013 summit

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

videos of 2013 summit

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

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

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.

Re: What is best Cassandra client?

Thanks I found the jar in the maven repository.   -Tony From: Theo Hultberg To: user@cassandra.apache.org; Tony Anecito Sent: Thursday, July 4, 2013 2:34 AM Subject: Re: What is best Cassandra client? Datastax Java driver: https://github.com/datastax/java-driver T# On Thu, Jul 4, 2013 a

Re: What is best Cassandra client?

2013/7/4 Tony Anecito > 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?

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 To: user@cassandra.apache.org; Tony Anecito Sent: Thursday, July 4, 2013 2:34 AM Subject: Re: What is best Cassandra client? Datastax Java driver: 

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. disabli

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 da

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 wrote: > yes, you can query local CF in system keyspace: > > select partitioner from system.local; > > > H > > > On 4 July 2013 13:02, Vivek Mishra wrote:

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 wrote: > 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 wr

Partitioner type

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

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 g

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 h

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 wrote: > Datastax Java driver: https://github.com/datastax/java-driver > > T# > > > On Thu, Jul 4, 2013 at 10:25 AM, Tony Anecito wrote: >> Hi All, >> What is the best client to use? I want to use CQ

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 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. > > Thanks! >

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!