Detecting failed nodes and restarting

2010-12-02 Thread Utku Can Topçu
Hi All, The question is really simple. Is there anyone out there using a set of scripts in production that detects failures of cassandra processes and restarts them or takes required actions. If so, how can we implement a generic solution for this problem? Regards, Utku

Best Practice for Data Center Migration

2010-12-02 Thread Jake Maizel
Hello, We have a ring of 12 nodes with 6 in one data center and 6 in another. We want to shutdown all 6 nodes in data center 1 in order to close it down. We are using a replication factor of 3 and are using RackAwareStrategy with version 0.6.6. Are there any best practices for doing this type

Re: cassandra version update and my cluster

2010-12-02 Thread aaron morton
Point releases,7.0 to 7.1, are normally in place upgrades one node at a time. The cluster will remain online at all times. AFAIK major version upgrades would normally allow for in place upgrade, supporting a mixed environment during the change over. If the on disk format changed there may be a

Re: how can i ran the word count example on windows?

2010-12-02 Thread aaron morton
chmod is used on linux to change the file permissions. It seems like hadoop links your on linux. What command are you running to get this error ? Aaron On 2 Dec 2010, at 21:03, Bingbing Liu wrote: i use the same configuration in eclispe both on windows and linux , on linux ,it goes well,

Re: Data Model Question

2010-12-02 Thread aaron morton
Have you considered using Solr / lucene for the search? It has a lot more search features, and it really good at faceted navigation through a product catalogue. It sounds like it would be a better fit for this task. You can build facets for your price ranges, do the product name thing and

Set an index on column

2010-12-02 Thread Joshua Partogi
Hi there, How do I set an index on a column in cassandra 0.7? This is what I am trying to do: [defa...@keyspace1] get Standard1 where user = 'jpartogi'; No indexed columns present in index clause with operator EQ I can not find this in the CLI help nor the wiki. Maybe I am not looking hard

Re: Set an index on column

2010-12-02 Thread Jonathan Ellis
It's part of update column family: [defa...@unknown] help update column family; ... - column_metadata: Metadata which describes columns of column family. Supported format is [{ k:v, k:v, ... }, { ... }, ...] Valid attributes: column_name, validation_class (see comparator),

Re: cassandra version update and my cluster

2010-12-02 Thread Gary Dusbabek
0.6-0.7 will require a full cluster restart. 0.7-0.8 will require a rolling restart, so long as CASSANDRA-1015 is completed. keyspace/cf definitions will be readable across major versions, or there will be a way provided to migrate them if that is not possible. Gary. On Wed, Dec 1, 2010 at

Re: Re: how can i ran the word count example on windows?

2010-12-02 Thread Bingbing Liu
hi ,arron ,thanks for your reply i run a single node cassandra instance on linux (IP:10.37.17.231) but i run the word count in the eclipse on windows with seting the host ip = 10.37.17.231 2010-12-02 Bingbing Liu 发件人: aaron morton 发送时间: 2010-12-02 19:04:13 收件人: user 抄送: 主题: Re:

Re: Data Model Question

2010-12-02 Thread Jake Luciani
You can also run Solr with Cassandra as the backend: https://github.com/tjake/Lucandra/tree/solandra /shameless_plug -Jake On Thu, Dec 2, 2010 at 6:27 AM, aaron morton aa...@thelastpickle.comwrote: Have you considered using Solr / lucene for the search? It has a lot more search features,

Get CF with where condition supplied by cassandra-cli

2010-12-02 Thread Yann Perchec, Novapost
Hello everybody, I'm playing since a couple of days with the cassandra-cli supplied with the Cassandra 0.7 RC. It seems that new request are possible : I'm very interested in the get cf where column = value. Does it mean that request with condition on column other than keys is now possible? Is

Re: Best Practice for Data Center Migration

2010-12-02 Thread Jonathan Ellis
On Thu, Dec 2, 2010 at 4:08 AM, Jake Maizel j...@soundcloud.com wrote: Hello, We have a ring of 12 nodes with 6 in one data center and 6 in another.  We want to shutdown all 6 nodes in data center 1 in order to close it down.  We are using a replication factor of 3 and are using

issue for cassandra-cli on 0.7-rc1

2010-12-02 Thread Yikuo Chan
Hi there , After install cassandra 0.7rc1 , I get no respond problem after execute cassandra-cli , please reference below log and help me to fix this issue : [r...@xxx cassandra]# bin/cassandra-cli --host 10.31.23.22 Connected to: xxx Test Cluster on 10.31.23.22/9160 Welcome to cassandra CLI.

Re: issue for cassandra-cli on 0.7-rc1

2010-12-02 Thread Norman Maurer
You need to terminate the command with a ;. Try: help; Bye, Norman 2010/12/2 Yikuo Chan yikuo.c...@gmail.com: Hi there , After install cassandra 0.7rc1 , I get no respond problem after execute cassandra-cli , please reference below log and help me to fix this issue : [r...@xxx

Re: issue for cassandra-cli on 0.7-rc1

2010-12-02 Thread Yikuo Chan
Hi Norman : it's work and thanks for your help .. Kevin On Fri, Dec 3, 2010 at 1:43 AM, Norman Maurer nor...@apache.org wrote: You need to terminate the command with a ;. Try: help; Bye, Norman 2010/12/2 Yikuo Chan yikuo.c...@gmail.com: Hi there , After install cassandra 0.7rc1

Re: [RELEASE] 0.7.0 rc1

2010-12-02 Thread Clint Byrum
On Wed, 2010-12-01 at 17:00 +0100, Olivier Rosello wrote: FYI, 0.7.0~rc1 debs are available in a new PPA for experimental releases: http://launchpad.net/~cassandra-ubuntu/+archive/experimental It seems there is a dependancy on libjets3t-java Is it really needed ? This dependancy

Re: Get CF with where condition supplied by cassandra-cli

2010-12-02 Thread Aaron Morton
AFAIK there is not a definitive source, but...Take a look at the API documentation for version 0.7http://wiki.apache.org/cassandra/API07The cli will be making a call to get_indexed_slices()Cassandra.yaml provides some help about how to define the index using yaml.The cli also has online help,

Re: Data Model Question

2010-12-02 Thread Pablo D. Salgado
Hello Aaron and Jake, Thank you for your replay. I've worked with cassandra for 6 month but I never use Lucandra. I will try Lucandra, but I must ask (before start), Is possible reach my searching/pagination/sorting requeriments with Lucandra? Thank you in advance, Pablo 2010/12/2 Jake Luciani

Re: Data Model Question

2010-12-02 Thread Aaron Morton
I say yes to all your questions about what you can do with Solr.Some background the on the technology...Lucene is a Java library for doing full text searchhttp://lucene.apache.org/java/docs/index.htmlSolr turns lucene into a HTTP server and adds a bunch of other features such as making it easier

0.7RC1 cassandra-env.sh or cassandra.in.sh?

2010-12-02 Thread Thor Carpenter
Hi All, After installing 0.7RC1 RPM on CentOS and starting the cassandra service I am confused by the presence of duplicate and conflicting JVM params. There seem to be multiple places where JVM_OPTS are set. Is this a known issue? Any recommendations? Thanks! -Thor # find / -name

Re: 0.7RC1 cassandra-env.sh or cassandra.in.sh?

2010-12-02 Thread Nick Bailey
They should be set in cassandra-env.sh. Did you build the rpm yourself using the spec file in the source? If so its probably a bug. If not where did you get the rpm file from? On Thu, Dec 2, 2010 at 4:07 PM, Thor Carpenter tcarpen...@mediosystems.comwrote: Hi All, After installing 0.7RC1 RPM

Re: 0.7RC1 cassandra-env.sh or cassandra.in.sh?

2010-12-02 Thread Thor Carpenter
The rpm I'm using is: http://rpm.riptano.com/EL/6/x86_64/cassandra07-0.7.0-0rc1.el6.noarch.rpm. Yes, seems like a bug. I created CASSANDRA-1808https://issues.apache.org/jira/browse/CASSANDRA-1808 . Thanks, -Thor On Dec 2, 2010, at 2:42 PM, Nick Bailey wrote: They should be set in

Re: Secondary index on SuperColumn Family , Casandra 0.7beta2

2010-12-02 Thread Tyler Hobbs
Unfortunately, super columns families are not yet supported for secondary indexes. - Tyler On Thu, Dec 2, 2010 at 5:22 PM, Nick Santini nick.sant...@kaseya.comwrote: Hi, Im creating a column family and adding some secondary indexes on the column definition for some columns inside my super

Re: Secondary index on SuperColumn Family , Casandra 0.7beta2

2010-12-02 Thread Jason Pell
I think you will find secondary indexes are not supported for super columns Sent from my iPhone On Dec 3, 2010, at 10:22, Nick Santini nick.sant...@kaseya.com wrote: Hi, Im creating a column family and adding some secondary indexes on the column definition for some columns inside my super

Re: Re: how can i ran the word count example on windows?

2010-12-02 Thread CassUser CassUser
You can install cygwin in order to run mapred job locally on windows On Thu, Dec 2, 2010 at 5:57 AM, Bingbing Liu rucb...@gmail.com wrote: hi ,arron ,thanks for your reply i run a single node cassandra instance on linux (IP:10.37.17.231) but i run the word count in the eclipse on windows

Re: pid file is not created in Windows Environment....

2010-12-02 Thread Eric Evans
On Tue, 2010-11-30 at 20:49 -0800, rambabu pakala wrote: Can you Please help me, why the pid file is not created in windows environment when I try with C:\apache-cassandra-0.6.6 \bincassandra.bat -p c.pid ? We don't seem to have a very large base of Windows users so those scripts aren't as

Re: How to shutdown Cassandra on Ubuntu?

2010-12-02 Thread Eric Evans
On Wed, 2010-12-01 at 10:39 -0700, Melton Low wrote: I am just starting to play with Cassandra. My environment is Ubuntu Lucid 10.04 and latest Cassandra stable 0.6.8 binaries. I am unclear on how to shut down the Cassandra server. Documentation is quite clear on starting up the server.

Re: Can not connect to cassandra 0.7 using CLI

2010-12-02 Thread Eric Evans
On Thu, 2010-12-02 at 08:11 +1100, Joshua Partogi wrote: It is set to localhost I didn't change it and it is the same as configured in 0.6.8. Why doesn't it work out of the box? Thanks heaps. Try netstat -nl | grep 9160. Is the node listening on 9160? Which interface is it bound to? --

[no subject]

2010-12-02 Thread Eric Evans
On Wed, 2010-12-01 at 23:13 +0100, Moldován Eduárd wrote: unsubscribe http://wiki.apache.org/cassandra/FAQ#unsubscribe -- Eric Evans eev...@rackspace.com

Fetch a SuperColumn based on value of column

2010-12-02 Thread Narendra Sharma
Hi, My schema has a row that has thousands of Super Columns. The size of each super column is around 500B (20 columns). I need to query 1 SuperColumn based on value of one of its column. Something like SELECT SuperColumn FROM Row WHERE SuperColumn.column=value Questions: 1. Is this possible

Re: Can not connect to cassandra 0.7 using CLI

2010-12-02 Thread Joshua Partogi
Hi Eric, Thanks for the hint. I have found out that if there is an exception thrown, the thrift server won't be started. It is working fine now. Kind regards, joshua. On Fri, Dec 3, 2010 at 10:52 AM, Eric Evans eev...@rackspace.com wrote: On Thu, 2010-12-02 at 08:11 +1100, Joshua Partogi

Re: Secondary index on SuperColumn Family , Casandra 0.7beta2

2010-12-02 Thread Nick Santini
Thanks for the answers, cant wait for the feature to come :-) I guess Im gonna have to provide my own for a while Nicolas Santini Director of Cloud Computing Auckland - New Zealand (64) 09 914 9426 ext 2629 (64) 021 201 3672 On Fri, Dec 3, 2010 at 12:30 PM, Jason Pell jasonmp...@gmail.com

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Nick Santini
Hi, as I got answered on my mail, secondary indexes for super column families is not supported yet, so you have to implement your own easy way: keep another column family where the row key is the value of your field and the columns are the row keys of your super column family (inverted index)

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Nick Santini
actually, the solution would be something like my last mail, but pointing to the name of the super column and the row key Nicolas Santini Director of Cloud Computing Auckland - New Zealand (64) 09 914 9426 ext 2629 (64) 021 201 3672 On Fri, Dec 3, 2010 at 1:08 PM, Nick Santini

Re: Data Model Question

2010-12-02 Thread Pablo D. Salgado
Hello Aaron, Thanks for your reply. I will try it. Greetings, Pablo 2010/12/2 Aaron Morton aa...@thelastpickle.com I say yes to all your questions about what you can do with Solr. Some background the on the technology... Lucene is a Java library for doing full text search

Re: Re: Re: how can i ran the word count example on windows?

2010-12-02 Thread Bingbing Liu
yes , i can resolve the problem using cygwin but i want to know the reason for the problem , such as : the MR can't recognize the type of OS or may be i should configure it in the my word count? 2010-12-03 Bingbing Liu 发件人: CassUser CassUser 发送时间: 2010-12-03 07:38:32 收件人: user

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Aaron Morton
You can use column and super column names with the get_slice() function without 0.7 secondary indexes. I'm assuming that the original query was to test for the existence of a column by name.In the case below, to retrieve the full super column would require to request...First to test the condition.

Re: Sorted Integer - UUID

2010-12-02 Thread Brandon Williams
On Wed, Dec 1, 2010 at 8:33 AM, Benjamin Waldher l...@laserbunny.netwrote: How can I have a sorted set of rows of Integer - UUID where the integer may exist many times? If you need to repeat an integer as a column name, add entropy and use a BytesType column. Pack your integer in big endian

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Narendra Sharma
Thanks Aaron! The first request requires you to know the SuperColumn name. In my case I don't know the SuperColumn name cause if I know then I can read the super column. I need to find the SuperColumn that has column with given value for a given column. The usecase is that application allows