how to delete data with level compaction

2012-01-27 Thread Thorsten von Eicken
I'm using level compaction and I have about 200GB compressed in my largest CFs. The disks are getting full. This is time-series data so I want to drop data that is a couple of months old. It's pretty easy for me to iterate through the relevant keys and delete the rows. But will that do anything? I

Re: How to create a table in Cassandra

2012-01-27 Thread R. Verlangen
A "table" is called a "column family" in Cassandra. >From the CLI you can just create one by typing: create column family MyApplication; -- Forwarded message -- > From: > Date: Fri, Jan 27, 2012 at 2:36 PM > Subject: How to create a table in Cassandra > To: d...@cassandra.apac

Re: Restart cassandra every X days?

2012-01-27 Thread R. Verlangen
Ok. Seems that an upgrade might fix these problems. Is Cassandra 1.x.x stable enough to upgrade for, or should we wait for a couple of weeks? 2012/1/27 Edward Capriolo > I would not say that issuing restart after x days is a good idea. You are > mostly developing a superstition. You should find

Re: how stable is 1.0 these days?

2012-01-27 Thread David Carlton
Thanks to people for their input on this! -- David Carlton carl...@sumologic.com

Fwd: How to create a table in Cassandra

2012-01-27 Thread Nate McCall
[moving to user@cassandra.apache.org] Since you have it installed, you can start experimenting with the CLI. Take a look at the following: http://www.datastax.com/docs/1.0/dml/using_cli cql-shell as well if you have python in your environment: http://www.datastax.com/docs/1.0/dml/using_cql -

Re: Thift vs. CQL

2012-01-27 Thread Jonathan Ellis
[moving to user list] There are no plans to remove the Thrift API. On Fri, Jan 27, 2012 at 6:26 AM, bxqdev wrote: > Hello! > >  Datastax's Cassandra documentation says that CQL API is the future of > Cassandra API. It's also says that eventually Thift API will be removed > completely. Is it true

Problematic deletes in 0.8.8

2012-01-27 Thread Maxim Potekhin
Hello, after I thought I was out of the woods with data deletion in 0.8.8, I unfortunately see "undead" data and other strange behavior. Let me clarify: a) I do run repair and compaction well within GC_GRACE b) deletes happen daily c) after a few repairs, when I run an indexed query on the dat

Re: Restart cassandra every X days?

2012-01-27 Thread Edward Capriolo
I would not say that issuing restart after x days is a good idea. You are mostly developing a superstition. You should find the source of the problem. It could be jmx or thrift clients not closing connections. We don't restart nodes on a regiment they work fine. On Thursday, January 26, 2012, Mike

RE: SQL DB Integration

2012-01-27 Thread Viktor Jevdokimov
Hello Krassimir, >From a typical programmer you should receive an answer, that this is possible, >but easy or difficult - depends. >From a typical consultand you should receive a question - why? > I am working on a project, for which I have to evaluate and recommend the > implementation of a ne

SQL DB Integration

2012-01-27 Thread Krassimir Kostov
Hello! I am working on a project, for which I have to evaluate and recommend the implementation of a new database system, with the following major characteristics: * Operational scalability * Low cost * Ability to serve both as a data storage facility and an advanced data manipulation too