Re: AssertionError in hintedhandoff - 1.0.5

2011-12-06 Thread Sylvain Lebresne
Do you mind opening a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Thanks -- Sylvain On Tue, Dec 6, 2011 at 12:52 AM, Ramesh Natarajan rames...@gmail.com wrote: Hi,  We are running a 8 node cassandra cluster running cassandra 1.0.5. All our CF use leveled compaction.  We ran

Re: Re: Re: Cassandra DataModeling recommendations

2011-12-06 Thread pcohen
Thanks to both of you for these very useful and interesting links/proposals. Best Regards Hi Thanks for the answer, as I read the book on Cassandra, I was not aware at that time on Composite Key which I recently discovered.   Composite Type's are

Cassandra not suitable?

2011-12-06 Thread Patrik Modesto
Hi, I'm quite desperate about Cassandra's performance in our production cluster. We have 8 real-HW nodes, 32core CPU, 32GB memory, 4 disks in raid10, cassandra 0.8.8, RF=3 and Hadoop. We four keyspaces, one is the large one, it has 2 CFs, one is kind of index, the other holds data. There are

Re: CQL Install for 0.8.X?

2011-12-06 Thread Joe Stein
Thanks Eric! On Mon, Dec 5, 2011 at 10:38 PM, Eric Evans eev...@acunu.com wrote: On Mon, Dec 5, 2011 at 1:40 PM, Joe Stein crypt...@gmail.com wrote: Hey, trying to grab cqlsh for a 0.8.6 cluster but all the online docs I am finding are pointing to

Re: Second Cassandra users survey

2011-12-06 Thread Matthias Pfau
It took some time to gather our requirements and to check what are our most important needs. However, here they are: * Column position range queries: We would like to access columns not by their name, but by their position in the row. Example: row(A:v1, B:v2, C:v3, D:v4); ; ordered by

Re: best practices for simulating transactions in Cassandra

2011-12-06 Thread Jérémy SEVELLEC
Hi John, I had exactly the same reflexions. I'm using zookeeper and cage to lock et isolate. but how to rollback? It's impossible so try replay! the idea is explained in this presentation http://www.slideshare.net/mattdennis/cassandra-data-modeling (starting from slide 24) - insert your whole

Re: AssertionError in hintedhandoff - 1.0.5

2011-12-06 Thread Ramesh Natarajan
https://issues.apache.org/jira/browse/CASSANDRA-3579 thanks Ramesh On Tue, Dec 6, 2011 at 2:16 AM, Sylvain Lebresne sylv...@datastax.com wrote: Do you mind opening a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Thanks -- Sylvain On Tue, Dec 6, 2011 at 12:52 AM, Ramesh

Re: OutOfMemory Exception during bootstrap

2011-12-06 Thread Harald Falzberger
You are right Samal, configuring cassandra-env.sh a little bit and let it calculate heap size solved the problem! thank you! On Mon, Dec 5, 2011 at 11:23, Harald Falzberger h.falzber...@gmail.com wrote: I don't think that this is the problem because I'm testing on a supercomputer with 16T RAM.

Re: best practices for simulating transactions in Cassandra

2011-12-06 Thread John Laban
Ah, neat. It is similar to what was proposed in (4) above with adding transactions to Cages, but instead of snapshotting the data to be rolled back (the before data), you snapshot the data to be replayed (the after data). And then later, if you find that the transaction didn't complete, you just

cqlsh not returning the column name of the first column when reversed

2011-12-06 Thread Konstantin Naryshkin
I am running Cassandra 1.0.0. I am using cqlsh for inspecting my data (very useful tool, thank you whoever wrote it). I notice that when I query for the FIRST N REVERSED column, it is omitting the column name on the first column. For example, cqlsh SELECT FIRST 1 REVERSED * FROM netflow_raw;

Is this a limitation of CQL?

2011-12-06 Thread Peter Lin
I was doing some testing with CQL and noticed something. I'm guessing it's probably user error on my part, but just in case it isn't. If I execute a query like this, I get the following error Caused by: InvalidRequestException(why:No indexed columns present in by-columns clause with equals

Re: Is this a limitation of CQL?

2011-12-06 Thread Peter Lin
thanks for confirming that. I was guessing that was the rationale and it makes sense. Didn't want to make a stupid assumption. On Tue, Dec 6, 2011 at 4:14 PM, Jeremiah Jordan jeremiah.jor...@morningstar.com wrote: As designed in all versions.  The search queries have to have an indexed

cassandra most stable version ?

2011-12-06 Thread Pierre Chalamet
Hello, Recent problems with Cassandra 1.0.x versions seems to tell it is still not ready for prime time. We are currently using version 0.8.5 on our development cluster - although we have not seen much problems with this one, maybe recent versions of 0.8.x might be safer to use. So

Re: cassandra most stable version ?

2011-12-06 Thread Jahangir Mohammed
We are running 0.8.7. No big issues so far. Thanks, Jahangir. On Tue, Dec 6, 2011 at 5:05 PM, Pierre Chalamet pie...@chalamet.net wrote: Hello, ** ** Recent problems with Cassandra 1.0.x versions seems to tell it is still not ready for prime time. ** ** We are currently using

Re: Upgrade from 0.6 to 1.0

2011-12-06 Thread Jehan Bing
Found my problem: I was using a very old cassandra (0.6.1). So I upgraded to 0.6.13 first then I could start 1.0.5. And so by trial, I can then answer my other questions: - no, config-convert is not necessary and I can just edit the default cassandra.yaml - no, I don't need schematool, can just

Re: building a new email-like inbox service with cassandra

2011-12-06 Thread Rustam Aliyev
Hi, Just updating this thread: We've pushed initial version to github today. You can find sources, binary package and some information here: https://github.com/elasticinbox/elasticinbox/wiki Your feedback is most welcome. We can discuss it further on elasticin...@googlegroups.com mail

sstable count=0, why nodetool ring is not 0

2011-12-06 Thread 祝海通
hi,all We are using Cassandra 1.0.2. I am testing the TTL with loading 400G. When all the data are expired, I waited for some hours. Later, the nodetool ring is still have 90GB. So I made a major compaction. Then there are 30GB from the nodetool ring. After I saw the file system,I found there are

Re: Cassandra not suitable?

2011-12-06 Thread Peter Schuller
I'm quite desperate about Cassandra's performance in our production cluster. We have 8 real-HW nodes, 32core CPU, 32GB memory, 4 disks in raid10, cassandra 0.8.8, RF=3 and Hadoop. We four keyspaces, one is the large one, it has 2 CFs, one is kind of index, the other holds data. There are