BloomFilter

Hi - Couple of questions - 1) What is the ratio of the sstable file size to bloom filter size ? If i have a sstable of 1 GB, what is the approximate bloom filter size ? Assuming 0.000744 default val configured. 2) The bloom filters are stored in RAM but not in help from 1.2 onwards ? 3)

Upgrade to Cassandra 1.2

I'd like to upgrade from 1.1.6 to 1.2.1, one big feature in 1.2 is that it can have multiple tokens in one node. but there is only one token in 1.1.6. how can I upgrade to 1.2.1 then breaking the token to take advantage of this feature? I went through this doc but it does not say how to change the

Re: Secondary index query + 2 Datacenters + Row Cache + Restart = 0 rows

Can you run the select in cqlsh and enabling tracing (see the cqlsh online help). If you can replicate it then place raise a ticket on https://issues.apache.org/jira/browse/CASSANDRA and update email thread. Thanks - Aaron Morton Freelance Cassandra Developer New Zealand @aa

Index file

Hi - The index files created for the SSTables. Do they contain a sampling or the complete index ? Cassandra on startup loads these files based on the sampling rate in Cassandra.yaml ..right ?

Re: Possible issue in IndexedSliceReader.java ?

What version are you looking at ? I *think* it should be testing against the start of the next slice. It should not have to test any more as per the comments at the top of IndexedSliceReader, the slices are ordered. (I'm not sure if slices can overlap though) The best way I can think to exercis

Re: conditional update or insert

> Any alternative to achieve this? Nothing server side. i.e. you cannot do Update foo set bar='baz' where timestamp < new_timestamp You can monkey around with the timestamps a little though. Cassandra will return you the column value with the highest (internal cassandra) time stamp. Now days mo

Re: initial_token

If you are using Murmur3 partitioner and do not wish to partake in vnodes you can still calculate inital_tokens. There is a guide here http://www.datastax.com/docs/1.2/initialize/token_generation#calculating-tokens-for-the-murmur3partitioner Cheers - Aaron Morton Freelance Ca

CQL : Date comparison in where clause fails

I've got a table that has a column called date. I created an index on the column date with the following command: CREATE INDEX date_key ON ola (date); Now, I can perform the following command: select * from ola where date = '2013-01-01' limit 10; The results are correctly displayed. But the th

Re: Start token sorts after end token

On Fri 01 Feb 2013 06:56:54 PM CST, Jeremy Hanna wrote: See https://issues.apache.org/jira/browse/CASSANDRA-5168 - should be fixed in 1.1.10 and 1.2.2. On Jan 30, 2013, at 9:18 AM, Tejas Patil wrote: While reading data from Cassandra in map-reduce, I am getting "InvalidRequestException(why:

Re: Issues with CQLSH in Cassandra 1.2

On Tue 29 Jan 2013 03:55:52 AM CST, aaron morton wrote: I was able to replicate it… $ bin/nodetool -h 127.0.0.1 -p 7100 describering foo Schema Version:253da4a3-e277-35b5-8d04-dbeeb3c9508e TokenRange: TokenRange(start_token:3074457345618258602, end_token:-9223372036854775808, endpoints

Re: Start token sorts after end token

On Fri 01 Feb 2013 06:56:54 PM CST, Jeremy Hanna wrote: See https://issues.apache.org/jira/browse/CASSANDRA-5168 - should be fixed in 1.1.10 and 1.2.2. On Jan 30, 2013, at 9:18 AM, Tejas Patil wrote: While reading data from Cassandra in map-reduce, I am getting "InvalidRequestException(why:

Re: Issues with CQLSH in Cassandra 1.2

Right, at that point either, cassandra-cli or cqlsh will not see any endpoint. Only after you drop the keyspace and re-create it with cassandra-cli will properly work. Thanks, Gabi On 2/3/13 2:15 AM, Manu Zhang wrote: On Tue 29 Jan 2013 03:55:52 AM CST, aaron morton wrote: I was able to repli