Re: Admin for cassandra?

2012-11-15 Thread Timmy Turner
I think an eclipse plugin would be the wrong way to go here. Most people probably just want to browse through the columnfamilies and see whether their queries work out or not. This functionality is imho best implemented as some form of a light-weight editor, not a full blown IDE. I do have somethi

Re: Offsets and Range Queries

2012-11-15 Thread Ravikumar Govindarajan
Thanks Ed, for the clarifications Yes you are correct that the apps have to handle repeatable reads and not the databases themselves when using absolute offsets, but SQL databases do provide such an option at app's peril!!! "Slices have a fixed size, this ensures that the the "query" does not exe

Re: Admin for cassandra?

2012-11-15 Thread Edward Capriolo
We should build an eclipse plugin named Eclipsandra or something. On Thu, Nov 15, 2012 at 9:45 PM, Wz1975 wrote: > Cqlsh is probably the closest you will get. Or pay big bucks to hire someone > to develop one for you:) > > > Thanks. > -Wei > > Sent from my Samsung smartphone on AT&T > > > ---

RE: Admin for cassandra?

2012-11-15 Thread Wz1975
Cqlsh is probably the closest you will get. Or pay big bucks to hire someone to develop one for you:) Thanks. -Wei Sent from my Samsung smartphone on AT&T Original message Subject: Admin for cassandra? From: Kevin Burton To: user@cassandra.apache.org CC: Is there an ID

Re: Question regarding the need to run nodetool repair

2012-11-15 Thread Rob Coli
On Thu, Nov 15, 2012 at 4:12 PM, Dwight Smith wrote: > I have a 4 node cluster, version 1.1.2, replication factor of 4, read/write > consistency of 3, level compaction. Several questions. Hinted Handoff is broken in your version [1] (and all versions between 1.0.0 and 1.0.3 [2]). Upgrade to 1.1.

RE: Question regarding the need to run nodetool repair

2012-11-15 Thread Dwight Smith
Thanks From: Edward Capriolo [mailto:edlinuxg...@gmail.com] Sent: Thursday, November 15, 2012 4:30 PM To: user@cassandra.apache.org Subject: Re: Question regarding the need to run nodetool repair On Thursday, November 15, 2012, Dwight Smith wrote: > I have a 4 node cluster, version 1.1

Re: Question regarding the need to run nodetool repair

2012-11-15 Thread Edward Capriolo
On Thursday, November 15, 2012, Dwight Smith wrote: > I have a 4 node cluster, version 1.1.2, replication factor of 4, read/write consistency of 3, level compaction. Several questions. > > > > 1) Should nodetool repair be run regularly to assure it has completed before gc_grace? If it is no

Question regarding the need to run nodetool repair

2012-11-15 Thread Dwight Smith
I have a 4 node cluster, version 1.1.2, replication factor of 4, read/write consistency of 3, level compaction. Several questions. 1) Should nodetool repair be run regularly to assure it has completed before gc_grace? If it is not run, what are the exposures? 2) If a node goes down

cassandra-sharp 2.0-ALPHA available

2012-11-15 Thread Pierre Chalamet
Hi all, I'm happy to announce a new release of cassandra-sharp (version 2.0-alpha), a .NET client for Cassandra - all bits are available at http://code.google.com/p/cassandra-sharp/. This version is quite special because only the CQL Binary Protocol interface is supported ! Yes, Thrift is d

Admin for cassandra?

2012-11-15 Thread Kevin Burton
Is there an IDE for a Cassandra database? Similar to the SQL Server Management Studio for SQL server. I mainly want to execute queries and see the results. Preferably that runs under a Windows OS. Thank you.

Datatype Conversion in CQL-Client?

2012-11-15 Thread Timmy Turner
Does the official/built-in Cassandra CQL client (in 1.2) offer any built-in option to get direct values/objects when reading a field, instead of just a byte array?

Re: Upgrade 1.1.2 -> 1.1.6

2012-11-15 Thread Alain RODRIGUEZ
Here is an example of the increase for some counter (counting events per hour) time (UTC) 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Good value 88 44 26 35 26 86 187 251 455 389 473 367 453 373 C* counter 149 82 45 68 38 146 329 414 746 566 473 377 453 373 I finished my Cassandra 1.1.6 upgrades at 9

Re: Looking for a good Ruby client

2012-11-15 Thread Harry Wilkinson
Update on this: someone just pointed me towards the Cequel gem: https://github.com/brewster/cequel The way it's described in the readme it looks like exactly what I was looking for - a modern, CQL-based gem that is in active development and also follows the ActiveModel pattern. I'd be very intere

Re: unable to read saved rowcache from disk

2012-11-15 Thread Wei Zhu
Just curious why do you think row key will take 300 byte? If the row key is Long type, doesn't it take 8 bytes? In his case, the rowCache was 500M with 1.6M rows, so the row data is 300B. Did I miss something? Thanks. -Wei From: aaron morton To: user@cassandr

Re: Upgrade 1.1.2 -> 1.1.6

2012-11-15 Thread aaron morton
Can you provide an example of the increase ? Can you provide the log from startup ? Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 16/11/2012, at 3:21 AM, Alain RODRIGUEZ wrote: > We had an issue with counters ove

Re: unable to read saved rowcache from disk

2012-11-15 Thread aaron morton
For a row cache of 1,650,000: 16 byte token 300 byte row key ? and row data ? multiply by a java fudge factor or 5 or 10. Trying delete the saved cache and restarting. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.co

Re: unable to read saved rowcache from disk

2012-11-15 Thread Edward Capriolo
If the startup is taking a long time or not working and you believe it to be corrupt in some way it is safe to delete the saved cache files. If you think the process is taking longer then it should you could try attaching a debugger to the process. I try to avoid the row cache these days, even wit

Re: Offsets and Range Queries

2012-11-15 Thread Edward Capriolo
There are several reasons. First there is no "absolute offset". The rows are sorted by the data. If someone inserts new data between your query and this query the rows have changed. Unless you doing select queries inside a transaction with repeatable read and your database supports this the query

Re: Enable compression Cassandra 1.1.2

2012-11-15 Thread Alain RODRIGUEZ
We just upgrade to C* 1.1.6 We can now change anything using the CLI or cqlsh. So problem solved. 2012/11/14 Alain RODRIGUEZ > Oh! That's obviously the exact same issue. I didn't find this thread while > searching about my issue. > > We will upgrade. > > Thanks for the link. > > > 2012/11/14 a