Re: Snapshot failing on JSON files in 1.1.0

2012-05-28 Thread Alain RODRIGUEZ
/cassandra/data/cassa_teads/snapshots/20120528/stats_product-hc-233-Index.db (errno 0) at org.apache.cassandra.db.ColumnFamilyStore.snapshotWithoutFlush(ColumnFamilyStore.java:1433) at org.apache.cassandra.db.ColumnFamilyStore.snapshot(ColumnFamilyStore.java:1462)

Doubt in Row key range scan

2012-05-28 Thread Prakrati Agrawal
Dear all I have stored my data into Cassandra database in the format "tickerID_date". Now when I specify the row key range like 1_2012/05/24(start) to 1_2012/05/27(end) it says that the end key md5 value is lesser than start key md5 value. So I changed my start key to 1_2012/05/27 and end key

Re: Doubt in Row key range scan

2012-05-28 Thread Pierre Chalamet
Hi, It's normal. Keys to replicas are determined with a hash (md5) when using the random partitionner (which you are using I guess). You probably want to switch to the order preserving partionner or tweak your data model in order to rely on 2nd index for such filtering. - Pierre -Origin

Re: Doubt in Row key range scan

2012-05-28 Thread Alain RODRIGUEZ
You are using the Random Partitioner. Using the RP is a good thing because you avoid hot spots, but it has its defaults too. You can't scan a slice of row, they won't be ordered because all your keys are stored using their md5 values. You should review your data model to use columns to order your

RE: Doubt in Row key range scan

2012-05-28 Thread Prakrati Agrawal
Please could you tell me how to tweak my data model to rely on 2nd index ? Thank you Prakrati Agrawal | Developer - Big Data(I&D)| 9731648376 | www.mu-sigma.com From: Pierre Chalamet [mailto:pie...@chalamet.net] Sent: Monday, May 28, 2012 3:31 PM To: user@cassandra.apache.org Subject: Re: Doubt

project setup in asp.net Fluent Cassandra

2012-05-28 Thread Abhijit Chanda
Hi All, Right now i am trying to use Fluent Cassandra API for development in asp.net . For the same purpose i have downloaded the same source from github. But every time i add a new reference *fluentcassandra.dll*, i am unable to use it in my code. I am not able figure it out why this is happening

Re: Doubt in Row key range scan

2012-05-28 Thread Luís Ferreira
Check this out: http://www.anuff.com/2011/02/indexing-in-cassandra.html#more Or just google for wide row indexes. On May 28, 2012, at 11:22 AM, Prakrati Agrawal wrote: > Please could you tell me how to tweak my data model to rely on 2nd index ? > Thank you > > > Prakrati Agrawal | Developer -

commitlog_sync_batch_window_in_ms change in 0.7

2012-05-28 Thread osishkin osishkin
I'm experimenting with Cassandra 0.7 for some time now. I want to increase the value of commitlog_sync_batch_window_in_ms, without losing previous data. I can shut down my cluster, but I don't want to have the nodes ignore it due to some schema misoconfiguration etc when I get it up again. I apol

Re: commitlog_sync_batch_window_in_ms change in 0.7

2012-05-28 Thread Pierre Chalamet
Hi, Using nodetool for each node one by one: 1. disablethrift 2. drain 3. Shutdown your daemon 4. Modify the config 5. Restart the node You won't lose the data on your nodes - clients might see a node down, it is usually not a problem if your c* client is smart enough. You also won't lose updat

Doubts regarding compaction

2012-05-28 Thread Rajat Mathur
http://www.datastax.com/docs/1.0/operations/tuning On this page at last, there's a note about Major Compaction which says, Also, once you run a major compaction, automatic minor compactions are no > longer triggered frequently... Could anybody give an explanation for that, because as far as I t

Concurrency Control

2012-05-28 Thread Helen
Hi, what kind of Concurrency Control Method is used in Cassandra? I found out so far that it's not done with the MVCC Method and that no vector clocks are being used. Thanks Helen