Re: Schematool

2011-12-08 Thread Alain RODRIGUEZ
You should be able to use the CLI show schema yourkeyspace if your cassandra is recent enough ( = 0.8 if I remember well. I think it is better if you are in 0.8.7 because this command was fixed a couple of times in 8.6 and 8.7). You can put the show schema command into a file and call it with :

RE: Schematool

2011-12-08 Thread Michael Vaknine
Thank you Alain. michael From: Alain RODRIGUEZ [mailto:arodr...@gmail.com] Sent: Thursday, December 08, 2011 11:52 AM To: user@cassandra.apache.org Subject: Re: Schematool You should be able to use the CLI show schema yourkeyspace if your cassandra is recent enough ( = 0.8 if I

Cassandra jdbc-driver: no viable alternative at character '?'

2011-12-08 Thread Dinusha Dilrukshi
Hi, I am using cassandra-jdbc driver and following is my code snip written for delete a entry from column family. String query1 = delete from USER where key=?; PreparedStatement stmt = con.prepareStatement(query1); stmt.setString(1, dinusha); stmt.execute(); But I am getting following exception

Re: Atomic Operations in Cassandra

2011-12-08 Thread Sylvain Lebresne
On Thu, Dec 8, 2011 at 12:57 AM, Christof Bornhoevd cbornho...@gmail.com wrote: Hi All, I'm using Cassandra 1.0.3 (with Hector 0.7). What is the granularity of atomic read and write operations with Cassandra. I.e. is the insert or update of an individual column an atomic operation (in the

Re: Composite columns vs Protocol Buffers when all you need is to pack many things in a single column

2011-12-08 Thread Sylvain Lebresne
CompositeType is meant as a comparator to deal with composite column names. While it is possible to use it as a column value validator, I don't see any good use of that. -- Sylvain On Thu, Dec 8, 2011 at 6:13 AM, Asil Klin asdk...@gmail.com wrote: I know Composite columns are used for some very

Re: EC2 Maintenance Reboot

2011-12-08 Thread Peter Sanford
Just rebooting a machine with ephemeral drives is ok (it does an os level reboot). You will also keep the same IP address. If you stop and then start a machine with ephemeral drives you will lose data. See: http://alestic.com/2011/09/ec2-reboot-stop-start On Wed, Dec 7, 2011 at 6:43 PM,

Re: Cassandra jdbc-driver: no viable alternative at character '?'

2011-12-08 Thread Eric Evans
On Thu, Dec 8, 2011 at 4:20 AM, Dinusha Dilrukshi sdddilruk...@gmail.com wrote: I am using cassandra-jdbc driver and following is my code snip written for delete a entry from column family. Where did you get this driver? Is it a release, is it from git (and if so, when/which ID?). What

Re: Cassandra jdbc-driver: no viable alternative at character '?'

2011-12-08 Thread Dinusha Dilrukshi
Hi Evans, On Thu, Dec 8, 2011 at 8:59 PM, Eric Evans eev...@acunu.com wrote: On Thu, Dec 8, 2011 at 4:20 AM, Dinusha Dilrukshi sdddilruk...@gmail.com wrote: I am using cassandra-jdbc driver and following is my code snip written for delete a entry from column family. Where did you get

Single node

2011-12-08 Thread Stephen Pope
Is there a way to set up a single node cluster without specifying anything about the specific machine in cassandra.yaml? I've cleared the values from listen_address and rpc_address, but it complains upon startup that no other nodes can be seen (presumably because the ip in the seeds doesn't

Re: EC2 Maintenance Reboot

2011-12-08 Thread Vijay
In addition to the below i would also think of rebooting one at a time, just to be safe... folks in my corp are seeing the reboot fail because of EBS or S3 dependencies while booting the image. Regards, /VJ On Thu, Dec 8, 2011 at 3:04 AM, Peter Sanford psanf...@nearbuysystems.comwrote: Just

Re: Single node

2011-12-08 Thread Vijay
You can add a DNS entry with multiple IP's or something like a elastic ip which will keep switching between the active machines. or you can also write your custom seed provider class. Not sure if you will get a quorum when there dev's are on vacation :) Regards, /VJ On Thu, Dec 8, 2011 at

RE: Single node

2011-12-08 Thread Stephen Pope
Just solved it. I’m using localhost for the listen_address, 0.0.0.0 for the rpc_address, and 127.0.0.1 for the seeds. Cheers, Steve From: Vijay [mailto:vijay2...@gmail.com] Sent: Thursday, December 08, 2011 2:15 PM To: user@cassandra.apache.org Subject: Re: Single node You can add a DNS entry

CPU - 0% on nodes

2011-12-08 Thread Philippe
Hello (5-nodes, RF=3, 32GB RAM, 0.8.6, BOP, 6x2.33Ghz AMD cores) I'm encountering a weird issue on my CPU-bound workload. Basically I have two processes - one is sending counter increments as fast as it can for a couple tens of seconds. When few were issued it sleeps for 30 seconds - another is

Re: cassandra most stable version ?

2011-12-08 Thread Attila Babo
0.6.12, we had serious problem with 0.7.x and 0.8.x

Re: cassandra most stable version ?

2011-12-08 Thread Eric Tamme
On 12/08/2011 04:50 PM, Attila Babo wrote: 0.6.12, we had serious problem with 0.7.x and 0.8.x Seriously folks - dont make the choice to run 0.6.x build now, that would be like burning all our books (and e-books, and internets) and returning to the dark ages by choice. 0.7.x is the first

0.6.13-1.0 upgrade + node move - resurrected data

2011-12-08 Thread Jehan Bing
Hi, Here is what I do, starting from 4 0.6.13 nodes with RF 2: - repair all the nodes - compact all the nodes - upgrade to 1.0 - scrub all the nodes - repair all the nodes - compact all the nodes - move one node to a new token For some requests, I don't get the same result before and after the