Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread Praveen Baratam
I understand that there will be contention regarding which *n* columns are the current *n* columns but as mentioned previously the goal is to limit the accumulation of data as in our use-case some row keys can receive fairly heavy inserts. For people requiring precise set of current columns that fe

Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread aaron morton
During compaction, both automatic / minor and manual / major. The performance drop is having a lot of expired columns that have not been purged by compaction as they must be read and discarded during reads. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thel

emptying my cluster

2012-01-02 Thread Alexandru Sicoe
Hi everyone and Happy New Year! I need advice for organizing data flow outside of my 3 node Cassandra 0.8.6 cluster. I am configuring my keyspace to use the NetworkTopologyStrategy. I have 2 data centers each with a replication factor 1 (i.e. DC1:1; DC2:1) the configuration of the PropertyFileSnit

Re: column family names

2012-01-02 Thread aaron morton
From the help for create column family in the CLI… - name: Name of the new column family. Names may only contain letters, numbers and underscores. The CF name is used as part of a file name that includes other information and the "-" is used as a separator. Cheers - Aaron Mo

Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread R. Verlangen
@Aaron: Small side question, when do columns with a past TTL get removed? On a repair, (minor) compaction, or .. ? Does it have a performance drop if that's happening? 2012/1/2 aaron morton > Even if you had compaction enforcing a limit on the number of columns in a > row, there would still be i

Re: Row or Supercolumn with approximately n columns

2012-01-02 Thread aaron morton
Even if you had compaction enforcing a limit on the number of columns in a row, there would still be issues with concurrent writes at the same time and with read-repair. i.e. node a says the this is the first n columns but node b says something else, you only know who is correct at read time. H

Re: Cassandra WebUI with Sources released

2012-01-02 Thread Tim Dunphy
Nice work! It's beautiful can't wait to play with it! :) On Mon, Jan 2, 2012 at 12:48 PM, Markus Wiesenbacher | Codefreun.de wrote: > Hi, > > > > I wish you all a happy and healthy new year! > > > > As you may remember, I coded a little GUI for Apache Cassandra. Now I did > set up a little projec

Cassandra WebUI with Sources released

2012-01-02 Thread Markus Wiesenbacher | Codefreun.de
Hi, I wish you all a happy and healthy new year! As you may remember, I coded a little GUI for Apache Cassandra. Now I did set up a little project homepage where you can download it, including the sources: http://www.codefreun.de http://www.codefreunde.com Markus ;)

Re: Composite column names: How much space do they occupy ?

2012-01-02 Thread Ertio Lew
Yes that makes a lot of sense! on using remaining() method I see the proper expected sizes. On Mon, Jan 2, 2012 at 5:26 PM, Sylvain Lebresne wrote: > I am not familiar enough with Hector to tell you if it is doing something > special here, but note that: > > 1) you may have better luck getting

Re: Composite column names: How much space do they occupy ?

2012-01-02 Thread Sylvain Lebresne
I am not familiar enough with Hector to tell you if it is doing something special here, but note that: 1) you may have better luck getting that kind of question answered quickly by using the Hector mailing list. 2) that may or may not change what you're seeing (since again I don't know what Hecto

Re: Accessing expired data

2012-01-02 Thread Sylvain Lebresne
On Mon, Jan 2, 2012 at 11:51 AM, Thibaut Britz wrote: > Hi, > > due to a misconfiguration on our site, some parts of our data got saved with > a wrong expiration date, which expired just recently. > > How can I recover the data? > Is it sufficient to copy over a backup of the tables into the table

Re: Composite column names: How much space do they occupy ?

2012-01-02 Thread Ertio Lew
Sorry I forgot to tell that I'm using Hector to communicate with Cassandra. CS.toByteBuffer is to convert the composite type name to ByteBuffer. Can anyone aware of Hector API enlighten me why am I seeing this size for the composite type names. On Mon, Jan 2, 2012 at 2:52 PM, aaron morton wrote

Accessing expired data

2012-01-02 Thread Thibaut Britz
Hi, due to a misconfiguration on our site, some parts of our data got saved with a wrong expiration date, which expired just recently. How can I recover the data? Is it sufficient to copy over a backup of the tables into the table directory and iterate over the table (e.g. Read.ALL). Does cassand

Re: Dealing with "Corrupt (negative) value length encountered"

2012-01-02 Thread aaron morton
I would try to nodetool scrub the data on the node that that sent the bad data in the stream. You may be able to work which node from the logs, or it may be easier to just scrub them all. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickl

Re: CLI exception :: A long is exactly 8 bytes: 1

2012-01-02 Thread aaron morton
If you use the --debug flag when you start the CLI it always will print full stack traces. What is the CF definition ? I'm guessing the column_metadata specifies that the age column is a Long Was there existing data in the age column and if so how was it encoded ? Was the existing data was e

Re: rename column family

2012-01-02 Thread aaron morton
Renaming a CF is not directly supported. You can: 1) Add the new CF using the CLI or CQL 2) On each node copy the SSTable files and use the new CF name. 3) Drop the old CF using the CLI or CQL 4) The Drop CF command will create a snapshot, you may want to delete this. Hope that helps. --

Re: Composite column names: How much space do they occupy ?

2012-01-02 Thread aaron morton
What is the definition of the composite type and what is CS.toByteBuffer ? CompositeTypes have a small overhead see https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/marshal/CompositeType.java Hope that helps. Aaron - Aaron Morton Freelance Develo

Re: Cassandra stress test and max vs. average read/write latency.

2012-01-02 Thread Peter Schuller
> Is there any way to control the CPU load when using the "stress" benchmark? > I have some control over that with our home-grown benchmark, but I > thought it made sense to use the official benchmark tool as people might > more readily believe those results and/or be able to reproduce them.  But >

Re: How to convert start_token,end_token to real key value?

2012-01-02 Thread Philippe
No Le 2 janv. 2012 08:44, "ravikumar visweswara" a écrit : > Thank You Naren. If key k1>k2 (lexicologicaly), will md5(k1) > md5(k2)?. > > - R > > > On Sun, Jan 1, 2012 at 7:07 PM, Narendra Sharma > wrote: > >> A token is a MD5 hash (one way hash). You cannot compute the key given a >> token. You