how to avoid range ghosts?

2012-10-07 Thread Satoshi Yamada
Hi, What is the recommended way to avoid range ghost in using get_range()?In my case, order of the key is not problem. It seems valid to use random :start_key in every query, but i'm new to cassandra and do not know if it'srecommended or not. I use Cassandra 1.1.4 and ruby client. Range ghosts

Re: MBean cassandra.db.CompactionManager TotalBytesCompacted counts backwards

2012-10-07 Thread Edward Capriolo
I have not looked at this JMX object in a while, however the compaction manager can support multiple threads. Also it moves from 0-filesize each time it has to compact a set of files. That is more useful for showing current progress rather then lifetime history. On Fri, Oct 5, 2012 at 7:27 PM,

Re: how to avoid range ghosts?

2012-10-07 Thread Edward Capriolo
Read this: http://wiki.apache.org/cassandra/FAQ#range_ghosts Then say this to yourself: http://cn1.kaboodle.com/img/b/0/0/196/4/C1xHoQAAAZZL9w/ghostbusters-logo-i-aint-afraid-of-no-ghost-pinback-button-1.25-pin-badge.jpg?v=1320511953000 On Sun, Oct 7, 2012 at 4:15 AM, Satoshi Yamada

Re: cql3 and cli composites columns

2012-10-07 Thread Cyril Auburtin
Thanks Aaron, I don't understand what is the cli equivalent of: CREATE TABLE timeline ( user_id varchar, tweet_id bigint, author varchar, body varchar, PRIMARY KEY (user_id, tweet_id) ); 2012/10/3 aaron morton aa...@thelastpickle.com

Re: cql3 and cli composites columns

2012-10-07 Thread Tupshin Harper
Once you have created the CF from cqlsh, switch over to cassandra-cli and run describe schema. It will show you the schema for all your column families in syntax that can be passed back into cassandra-cli to create them. The cassandr-cli syntax that you are looking for is probably the and