Re: Error starting cassandra node

2012-08-07 Thread rajesh.ba...@orkash.com
Hi Ei, Thanks a lot.IT worked. The node has started after deleting the files from the system keyspace. Thanks Rajesh Kumar On Tuesday 07 August 2012 11:04 AM, 張 睿 wrote: Hello Kumar, If you've started cassandra on this node before, the cluster name would be stored in the system keyspace.

Re: Project Management

2012-08-07 Thread Roshni Rajagopal
Hi Baskar, The key aspect here is, you have to think of your queries , and denormalize. Here are my suggestions based on my understanding so far. You seem to have 2 queries A) what all users do I have B) what organizations do the users belong to The first can be a static column family- these

Re: Project Management

2012-08-07 Thread Baskar Sikkayan
Hi, Thank you very much for your useful info. I have one more doubt here. If i create one more column family based on my query instead of going with secondary index, Will it affect the write performance? Since i need to duplicate the data in the second column family as well while writing data,

Re: RE Restore snapshot

2012-08-07 Thread Jonathan Ellis
Yes. On Thu, Aug 2, 2012 at 5:33 AM, Radim Kolar h...@filez.com wrote: 1) I assume that I have to call the loadNewSSTables() on each node? this is same as nodetool refresh? -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra

Re: Error starting cassandra node

2012-08-07 Thread Abhijit Chanda
Perform these steps on each node: Start the Cassandra-cli connected to your node. Run the following: 1. use system; 2. set LocationInfo[utf8('L')][utf8('ClusterName')]=utf8('Brisk Cluster'); 3. exit; 4. Run nodetool flush on this node. 5. Update the cassandra.yaml file for the

How to purge the Hinted data from Cassandra

2012-08-07 Thread Roshan
Hi I have upgrade the production cassandra cluster to 1.0.11 version. But still one node sending hints to a other node in cluster every 10 mins. All the nodes in cluster are up and running and well balanced. Log says: 2012-08-08 08:56:54,380 INFO [HintedHandOffManager] Started hinted handoff

Re: change cluster name

2012-08-07 Thread Amit Kumar
[default@system] set LocationInfo[utf8('L')][utf8('Test Cluster')]=utf8('Jokeire Cluster'); Value inserted. You are missing set Amit On Aug 7, 2012, at 5:36 PM, Tim Dunphy wrote: hello, I'd like to change my cluster name from the default 'Test Cluster' to something a little more

Re: change cluster name

2012-08-07 Thread Tim Dunphy
Thanks! That got the value inserted properly [default@system] set LocationInfo[utf8('L')][utf8('Test Cluster')]=utf8('Jokefire Cluster'); Value inserted. Elapsed time: 5 msec(s). But if I go into the yaml file and set the cluster name # The name of the cluster. This is mainly used to prevent

CQL / cli question

2012-08-07 Thread Greg Fausak
I think I'm having a major brain fart here, I am just not getting something. I have the following CF declared in CQL -3 create columnfamily testCQL5( ac_event_id int, ac_c text, ac_mtcreation bigint, ac_action text , ac_id text, PRIMARY KEY (ac_c, ac_mtcreation)); I can do this: cqlsh:op2

Use of SSD for commitlog

2012-08-07 Thread Darvin Denmian
Hi, Can somebody tell me if is there some benefit in use SSD Disks for commitlog? THanks!

Assume Keys in cqlsh?

2012-08-07 Thread Jason Hill
Hello, I'm using: [cqlsh 2.0.0 | Cassandra 1.0.10 | CQL spec 2.0.0 | Thrift protocol 19.20.0] I have a column family with a key that is a blob so I query it like this: SELECT FIRST 10 1..1344385804 FROM myCF WHERE KEY = '436170616369747943616c63756c61746f727c33'; Is there any way to avoid

Re: change cluster name

2012-08-07 Thread Amit Kumar
Is your /etc/hosts correct? Does it have an entry for beta.jokefire.com What if you replace beta.jokefire.com with the ip address, can you connect? Can you telnet to beta.jokefire.com port 9160? Look in the system log and see if you have a log entry like INFO [main]

Re: change cluster name

2012-08-07 Thread Abhijit Chanda
have you flushed the node using NODETOOL after renaming the cluster?