Re: InvalidRequestException(why:Not enough bytes to read value of component 0)

2012-11-26 Thread aaron morton
It looks like the client is not sending the correct bytes. Are you using Hector or Astyanax? It kind of looks like you are using raw thrift, using a pre-written client is much easier. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thel

Re: Changing compression_parameters of exsisting CF

2012-11-26 Thread aaron morton
> is it expectable behaviour? or it's bug? It exhibits bug like qualities. Can you create a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? Thanks - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 27/11/2012, at

Re: key cache size in mb = 0 doesn't work?

2012-11-26 Thread Yiming Sun
Thank you very much Andras. I will try MX4J tomorrow. Also thanks for the pointers on nodetool. I just poked around a bit, and found that "info" would give you the cache statistics, and there are also "invalidatekeycache" and "invalidaterowcache". I think these are exactly what I need. -- Y.

Re: key cache size in mb = 0 doesn't work?

2012-11-26 Thread Andras Szerdahelyi
If its the RMI horror ( registry port + actual port ) you are worried about, enabling MX4J in cassandra-env.sh for the HTTP transport ( http://wiki.apache.org/cassandra/Operations#Monitoring_with_MX4J ) could help although i never used it myself. Or you can just throw in the Jolokia JVM agent h

Re: key cache size in mb = 0 doesn't work?

2012-11-26 Thread Yiming Sun
Interesting -- I completely overlooked the OS cache aspect, but how long does the OS keep cached pages? It seems they reside in memory for 4 hours at least (which happens to be the default time for key cache).. The CF has over 2.6 million rows, and I am only fetching a random set of 5000 each time

Re: key cache size in mb = 0 doesn't work?

2012-11-26 Thread Andras Szerdahelyi
SSTables in http://en.wikipedia.org/wiki/Page_cache maybe? How many rows do you have in this CF? Are you getting all columns? What do the cassandra.db mbeans say ( hit ratio, cache requests, items etc ) regards, Andras On 27 Nov 2012, at 04:12, Yiming Sun wrote: > Hi, > > I am carrying out s

key cache size in mb = 0 doesn't work?

2012-11-26 Thread Yiming Sun
Hi, I am carrying out some performance test against a 6-node cassandra cluster (v1.1.0), and need to disable the key cache entirely as one of the scenarios. However, by setting key_cache_size_in_mb to 0, I am still seeing caching effects. For example, when I fetch a set of 5000 rows, the first t

Map Reduce and Cassandra with Trigger patch

2012-11-26 Thread Felipe Schmidt
I'm having some problems during running a Map Reduce program using Cassandra as input. I already right some MapRed programs using the cassandra 1.0.9, but now I'm trying with an old version with a patch that supports trigger. (this one: https://issues.apache.org/jira/browse/CASSANDRA-1311) When I

R: Re: Generic questions over Cassandra 1.1/1.2

2012-11-26 Thread cbert...@libero.it
Da: sylv...@datastax.com > The error message is indeed somewhat misleading and I've just committed a fix > to return a better message. But at the end of the day, the > limitation is > that ORDER BY is just not supported with 2ndary indexes. mmm this is not good news for the model I just designe

Re: Generic questions over Cassandra 1.1/1.2

2012-11-26 Thread Sylvain Lebresne
> > Thanks for the answer ... the error described before is: "ORDER BY is only > supported when the partition key is restricted by an EQ or an IN." > But I don't see how I didn't respect the rule ... > The error message is indeed somewhat misleading and I've just committed a fix to return a better

Re: about take snaphots

2012-11-26 Thread Francisco Trujillo Hacha
es, it is the normal behaviour for snapshots. > > > 2012/11/26 Francisco Trujillo Hacha > >> Hi >> >> I have a one node cassandra installation (1.1.6) with only one column >> family. When i tried to execute: >> >> ./nodetool -h 172.31.7.26 -p 7199 sna

Re: about take snaphots

2012-11-26 Thread Alain RODRIGUEZ
> Hi > > I have a one node cassandra installation (1.1.6) with only one column > family. When i tried to execute: > > ./nodetool -h 172.31.7.26 -p 7199 snapshot MykeyspaceName -t 20121126 > > The snapshot is stored in a snapshot folder inside the columnfamiliy (the > only t

Re: about take snaphots

2012-11-26 Thread Chuan-Heng Hsiao
e: > > ./nodetool -h 172.31.7.26 -p 7199 snapshot MykeyspaceName -t 20121126 > > The snapshot is stored in a snapshot folder inside the columnfamiliy (the > only that the keyspace has) instaead of the keyspace data folder. > > Is this the normal behavior of nodetool? > >

Re: InvalidRequestException(why:Not enough bytes to read value of component 0)

2012-11-26 Thread Cristina Rodriguez
> I am ussing this schema created with cassandra-cli: > > CREATE COLUMN FAMILY > Relationships > WITH > key_validation_class = 'CompositeType(UTF8Type, UTF8Type)' > AND > comparator = UTF8Type > > AND > default_validation_class = IntegerType > ; > > from > https://github.com/amorton

Changing compression_parameters of exsisting CF

2012-11-26 Thread Шамим
Hello users,   faced very strange behaviour when chnaging compression_parameters of exisiting CF. After changing the compaction strategy, compression_strategy returning back to the "SnappyCompressor". Using version 1.1.5. [cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 2.0.0 | Thrift protocol 19.32.0] I 

Re: Cassandra nodes failing with OOM

2012-11-26 Thread Ивaн Cобoлeв
Hi, all, thank you very much for the help. Aaron was right - we had a multiget_count query, which depending on the app input would result in a calculation performed for ~40k keys. We've released the fix and ~100 GCInspector warnings per day per node went to ~1 per day per 30 nodes :) Thank you v

Hive on Cassandra : issues in setup

2012-11-26 Thread Naveen Reddy
Hi,   I am trying to setup hive on Cassandra using https://github.com/riptano/hive/wiki/Cassandra-Handler-usage-in-Hive-0.7-with-Cassandra-0.7 . I do not find any better documentation, if you have any other pointers please provide them. I and trying to setup this without using brisk from DataSta

Re: Generic questions over Cassandra 1.1/1.2

2012-11-26 Thread cbert...@libero.it
>> Aaron first of all thanks for your precious help everytime …. >Thanks for using Cassandra since version 0.6 :) ahahah :-) >There are two types of CQL 3 tables, regular ones and those that use "COMPACT STORAGE". Regular CQL 3 tables are not visible to Thrift as they store some extra data tha

Re: Generic questions over Cassandra 1.1/1.2

2012-11-26 Thread Sylvain Lebresne
On Mon, Nov 26, 2012 at 8:41 AM, aaron morton wrote: > > Is there any noticeable performance difference between thrift or CQL3? > Off the top of my head it's within 5% (maybe 10%) under stress tests. See Eric's talk at the Cassandra SF conference for the exact numbers. Eric's benchmark results was