Re: Backup solution

Thank you. I have a high bandwidth connection. But that also means that regular repairs on the backup data-center will take a long time. 2013/3/14 Jabbar Azam aja...@gmail.com Hello, If the live data centre disappears restoring the data from the backup is going to take ages especially if the

Re: cql query not giving any result.

Hi, Is it possible in Cassandra to make multiple column with same name ?, like in this particular scenario I have two column with same name as key, first one is rowkey and second on is column name . Thanks and Regards Kuldeep On Fri, Mar 15, 2013 at 4:05 PM, Kuldeep Mishra

Re: cql query not giving any result.

Here is a list of keywords and whether or not the words are reserved. A reserved keyword cannot be used as an identifier unless you enclose the word in double quotation marks. Non-reserved keywords have a specific meaning in certain context but can be used as an identifier outside this context.

Re: cql query not giving any result.

On Fri, Mar 15, 2013 at 11:43 AM, Kuldeep Mishra kuld.cs.mis...@gmail.comwrote: Hi, Is it possible in Cassandra to make multiple column with same name ?, like in this particular scenario I have two column with same name as key, first one is rowkey and second on is column name . No, it

Re: cql query not giving any result.

Hi Sylvain, I created it using thrift client, here is column family creation script, Cassandra.Client client; CfDef user_Def = new CfDef(); user_Def.name = DOCTOR; user_Def.keyspace = KunderaExamples; user_Def.setComparator_type(UTF8Type);

Re: cql query not giving any result.

Ok. So it's a case when, CQL returns rowkey value as key and there is also column present with name as key. Sounds like a bug? -Vivek On Fri, Mar 15, 2013 at 5:17 PM, Kuldeep Mishra kuld.cs.mis...@gmail.comwrote: Hi Sylvain, I created it using thrift client, here is column family

Re: Backup solution

On Fri, Mar 15, 2013 at 3:12 AM, Rene Kochen rene.koc...@emea.schange.com wrote: Thank you. I have a high bandwidth connection. But that also means that regular repairs on the backup data-center will take a long time. Honestly, at this point I don't think anyone can provide you any good

Re: Backup solution

You can consider using a WAN optimization appliance such as a Riverbed Steelhead to significantly speed up your transfers, though that will cost. It is a common approach to speed up inter-datacenter transfers. Steelheads for the AWS EC2 cloud are also available. (Disclaimer: I used to write

Re: cassandra 1.2.2 build generates slightly different than one on website

Very weird. I went back and tried to reproduce it after cleaning all changes from git. I am not sure how that got deleted nor how I ended up with wordcount *.class files since I am not doing any map/reduce or anything…..oh well, must have made a mistake somewhere. Thanks, Dean From: Sylvain

Re: Can't replace dead node

I removed Priam and get the same picture. What I do is- I added to cassandra-env.sh two lines and start cassandra. JVM_OPTS=$JVM_OPTS -Dcassandra.initial_token=aaba JVM_OPTS=$JVM_OPTS -Dcassandra.replace_token=aaba Then I can successfully

Re: HintedHandoff IOError?

JMX ended up just with lots more IOErrors. Did a rolling restart of the cluster and removed the HH family in the mean time. That seemed to do the trick. Thanks! /Janne On Mar 14, 2013, at 06:58 , aaron morton aa...@thelastpickle.com wrote: What is the sanctioned way of removing hints? rm -f

secondary index problem

We have a CF with an indexed column 'type', but we get incomplete results when we query that CF for all rows matching 'type'. We can find the missing rows if we query by key. * we are seeing this on a small, single node, 1.2.2 instance with few rows. * we use thrift execute_cql_query, no CL

Secondary Indexes

We need to provide search capability based on a field that is a bitmap combination of 18 possible values. We want to use secondary indexes to improve performance. One possible solution is to create a named column for each value and have a secondary index for each of the 18 columns. Questions we

Re: secondary index problem

This could be either of the following bugs (which might be the same thing). I get it too every time I recycle a node on 1.1.10. https://issues.apache.org/jira/browse/CASSANDRA-4973 or https://issues.apache.org/jira/browse/CASSANDRA-4785 /Janne On Mar 15, 2013, at 23:24 , Brett Tinling

java.lang.OutOfMemoryError: unable to create new native thread

I have a Cassandra node that is going down frequently with 'java.lang.OutOfMemoryError: unable to create new native thread. Its a 16GB VM out of which 4GB is set as Xmx and there are no other process running on the VM. I have about 300 clients connecting to this node on an average. I have no

Cassandra Compression and Wide Rows

Hey Guys, I remember reading somewhere that C* compression is not very effective when most of the CFs are in wide-row format and some folks turn the compression off and use disk level compression as a workaround. Considering that wide rows with composites are first class citizens in CQL3, is

Waiting on read repair?

I've got a couple of questions related issues I'm encountering using Cassandra under a heavy write load: 1. With a ConsistencyLevel of quorum, does FBUtilities.waitForFutures() wait for read repair to complete before returning? 2. When read repair applies a mutation, it needs to obtain a lock for

Re: Backup solution

On Fri, Mar 15, 2013 at 10:35 AM, Rene Kochen rene.koc...@emea.schange.com wrote: Hi Aaron, We have many deployments, but typically: - Live cluster of six nodes, replication factor = 3. - A node processes more reads than writes (approximately 100 get_slices per/second, narrow rows). - Data

RE: java.lang.OutOfMemoryError: unable to create new native thread

I think I figured out where the issue is. I will keep you posted soon. From: as...@outlook.com To: user@cassandra.apache.org Subject: java.lang.OutOfMemoryError: unable to create new native thread Date: Fri, 15 Mar 2013 17:54:25 -0500 I have a Cassandra node that is going down frequently with

Re: Incompatible Gossip 1.1.6 to 1.2.1 Upgrade?

Thank you very much Aaron. I recall from the logs of this upgraded node to 1.2.2 reported seeing others as dead. Brandon suggested in https://issues.apache.org/jira/browse/CASSANDRA-5332 that I should at least upgrade from 1.1.7. So, I decided to try upgrading to 1.1.10 first before upgrading to

Re: cql query not giving any result.

Any suggestions? -Vivek On Fri, Mar 15, 2013 at 5:20 PM, Vivek Mishra mishra.v...@gmail.com wrote: Ok. So it's a case when, CQL returns rowkey value as key and there is also column present with name as key. Sounds like a bug? -Vivek On Fri, Mar 15, 2013 at 5:17 PM, Kuldeep Mishra

Re: hinted handoff disabling trade-offs

Thanks Aaron. I am using CL=ONE. read_repair_chance=0. The part which I'm wondering about is what happens to the internal Cassandra writes if Hinted Handoffs are disabled. I think I understand what it means for application-level data, but the part I'm not entirely sure about is what it could mean