BloomFilter

2013-02-02 Thread Kanwar Sangha
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

2013-02-02 Thread Daning Wang
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

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

2013-02-02 Thread aaron morton
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

Index file

2013-02-02 Thread Kanwar Sangha
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 ?

2013-02-02 Thread aaron morton
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

Re: conditional update or insert

2013-02-02 Thread aaron morton
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

Re: initial_token

2013-02-02 Thread aaron morton
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

CQL : Date comparison in where clause fails

2013-02-02 Thread Paul van Hoven
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

Re: Start token sorts after end token

2013-02-02 Thread Manu Zhang
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 tejas.patil...@gmail.com wrote: While reading data from Cassandra in map-reduce, I am getting

Re: Issues with CQLSH in Cassandra 1.2

2013-02-02 Thread Manu Zhang
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,

Re: Start token sorts after end token

2013-02-02 Thread Manu Zhang
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 tejas.patil...@gmail.com wrote: While reading data from Cassandra in map-reduce, I am getting

Re: Issues with CQLSH in Cassandra 1.2

2013-02-02 Thread Gabriel Ciuloaica
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