Re: trouble with deleted counter columns

2011-11-30 Thread Sylvain Lebresne
On Wed, Nov 30, 2011 at 8:36 AM, Thorsten von Eicken t...@rightscale.com wrote: Running a single 1.0.3 node and using counter columns I have a problem. I have rows with ~200k counters. I deleted a number of such rows and now I can't put counters back in, or really, I can't query what I put

Can't run cleanup

2011-11-30 Thread Viktor Jevdokimov
Cassandra version 0.8.7, after adding new nodes we can't run cleanup on any node. Log reports: Cleanup cannot run before a node has joined the ring New nodes has joined (one by one), all nodes up running, reading, writing... Not sending/receiving any streams on any node for more than 12 hours.

Cleanup in a write-only environment

2011-11-30 Thread David McNelis
In my understanding Cleanup is meant to help clear out data that has been removed. If you have an environment where data is only ever added (the case for the production system I'm working with), is there a point to automating cleanup? I understand that if we were to ever purge a segment of

RE: Can't run cleanup

2011-11-30 Thread Viktor Jevdokimov
Nodetool repair also don't start on all nodes, log is reporting: INFO 15:57:51,070 Starting repair command #2, repairing 0 ranges. INFO 15:57:51,070 Repair command #2 completed successfully Regular read repairs are working as reads and writes. Best regards/ Pagarbiai Viktor Jevdokimov

[RELEASE] Apache Cassandra 1.0.5 released

2011-11-30 Thread Sylvain Lebresne
As indicated in a preceding mail (http://goo.gl/R1r1V), the release of 1.0.4 unfortunately shipped with two important regressions. The Cassandra team is pleased to announce the release of Apache Cassandra version 1.0.5 that comes to fix those two issues[1], but is identical to 1.0.4 otherwise.

RE: [RELEASE] Apache Cassandra 1.0.5 released

2011-11-30 Thread Michael Vaknine
The files are not on the site The requested URL /apache//cassandra/1.0.5/apache-cassandra-1.0.5-bin.tar.gz was not found on this server. Thanks, Michael -Original Message- From: Sylvain Lebresne [mailto:sylv...@datastax.com] Sent: Wednesday, November 30, 2011 9:11 PM To:

Re: [RELEASE] Apache Cassandra 1.0.5 released

2011-11-30 Thread Brandon Williams
On Wed, Nov 30, 2011 at 1:29 PM, Michael Vaknine micha...@citypath.com wrote: The files are not on the site The requested URL /apache//cassandra/1.0.5/apache-cassandra-1.0.5-bin.tar.gz was not found on this server. It takes the mirrors some time to sync. -Brandon

RE: [RELEASE] Apache Cassandra 1.0.5 released

2011-11-30 Thread Michael Vaknine
Thanks, The files are there already. -Original Message- From: Brandon Williams [mailto:dri...@gmail.com] Sent: Wednesday, November 30, 2011 9:43 PM To: user@cassandra.apache.org Subject: Re: [RELEASE] Apache Cassandra 1.0.5 released On Wed, Nov 30, 2011 at 1:29 PM, Michael Vaknine

Cassandra_Jobs on Twitter

2011-11-30 Thread Jeremy Hanna
For those interested in Apache Cassandra related jobs - either hiring or in search of - there is now a @Cassandra_Jobs account on Twitter. You can either send posts to that account on twitter or send them to me at this email address with a public link to the job posting and I will tweet them.

RE: [RELEASE] Apache Cassandra 1.0.5 released

2011-11-30 Thread Michael Vaknine
Hi, Upgrade 1.0.3 to 1.0.5 I have this errors TST-Cass2 ERROR [Thread-58] 2011-11-30 20:40:17,449 AbstractCassandraDaemon.java (line 133) Fatal exception in thread Thread TST-Cass2 ERROR [Thread-58] 2011-11-30 20:40:17,449 java.lang.AssertionError TST-Cass2 ERROR [Thread-58] 2011-11-30

data modeling question

2011-11-30 Thread Deno Vichas
hey all! i'm started my first project using cassandra and some data model questions. i'm working on an app that fetches stock market data. i need to keep track of when i fetch a set of data for any given stock in any sector; here's what i think my model should look like; fetches : {

Re: data modeling question

2011-11-30 Thread David McNelis
Personally I would create a separate column family for each basic area. For example To organize my sectors and symbols I would create a column family where the key is the sector name and the column names are the symbols for that sector, i.e.: sector : { key: sector name Column names:

Re: Cleanup in a write-only environment

2011-11-30 Thread Nick Bailey
I believe you are mis-understanding what cleanup does. Cleanup is used to remove data from a node that the node no longer owns. For example when you move a node in the ring, it changes responsibility and gets new data, but does not automatically delete the data it used to be responsible for but no

Re: data modeling question

2011-11-30 Thread Deno Vichas
with the quote CF below how would one query for all keys that have a column name value that have a timeuuid of later than x minutes? i need to be able to find all symbols that have not been fetch in x minutes by sector. i know i get list of symbol by sector from my sector CF. thanks, deno

Re: data modeling question

2011-11-30 Thread David McNelis
You wouldn't query for all the keys that have a column name x exactly. Instead what you would do is for sector x grab your list of symbols S. Then you would get the last column for each of those symbols (which you do in different ways depending on the API), and then test if that date is within

Re: [RELEASE] Apache Cassandra 1.0.5 released

2011-11-30 Thread Jonathan Ellis
I don't think so. That code hasn't changed in a long time. Is it reproducible? On Wed, Nov 30, 2011 at 2:46 PM, Michael Vaknine micha...@citypath.com wrote: Hi, Upgrade 1.0.3 to 1.0.5 I have this errors TST-Cass2 ERROR [Thread-58] 2011-11-30 20:40:17,449 AbstractCassandraDaemon.java (line

can not create a column family named 'index'

2011-11-30 Thread Shu Zhang
Hi, just wondering if this is intentional: [default@test] create column family index; Syntax error at position 21: mismatched input 'index' expecting set null [default@test] create column family idx; b9aae960-1bb2-11e1--bf27a177f2f6 Waiting for schema agreement... ... schemas agree across the

Re: Cleanup in a write-only environment

2011-11-30 Thread Edward Capriolo
Your understanding of nodetool cleanup is not correct. cleanup is used only after cluster balancing like adding or removing nodes. It removes data that does not belong on the node anymore (in older versions it removed hints as well) Your debate is needing to run companion . In a write only

Re: Cleanup in a write-only environment

2011-11-30 Thread David McNelis
Thanks, folks. I think I must have read compaction, thought cleanup, and gotten muddled from there. David On Nov 30, 2011 6:45 PM, Edward Capriolo edlinuxg...@gmail.com wrote: Your understanding of nodetool cleanup is not correct. cleanup is used only after cluster balancing like adding or

Re: data modeling question

2011-11-30 Thread Deno Vichas
here's what i ended up, this seems to work for me. @Test public void readAndWriteSettingTTL() throws Exception { int ttl = 2; String columnFamily = Quote; SetString symbols = new HashSetString(){{ add(appl);

read repair and column range queries

2011-11-30 Thread Thorsten von Eicken
Looking at the docs, I can't conclusively answer this question: Suppose I make this CQL query with consistency factor 1 and read-repair 100%: select 'a'..'z' from cf where key = 'xyz' limit 5; Suppose the node I connect to has the key and responds with (improvised syntax): ['a'-0, 'c'-2, 'e'-4,