Re: repair takes two days, and ends up stuck: stream at 1096% (yes, really)

2010-11-14 Thread Chip Salzenberg
Excerpts from the log of X.20... Hope you can make something of it. --- INFO [MiscStage:1] 2010-11-14 17:19:33,105 StreamReplyVerbHandler.java (line 58) Need to re-stream file /var/lib/cassandra/d

Re: Cassandra: The Definitive Guide

2010-11-14 Thread Aaron Morton
Thanks, I'm happy with the digi version on safari or Kindle via the iPad. It costs a fortune to get dead tree's delivered all the way down in here New Zealand. Good luck with the book, am hoping to discover a bunch of details I've overlooked. AaronOn 15 Nov, 2010,at 01:45 PM, Eben Hewitt wrote:Hi

Re: Cassandra: The Definitive Guide

2010-11-14 Thread Eben Hewitt
Hi Aaron Cassandra: The Definitive Guide went to the printer a few days ago, so it's out of Rough Cuts. It should be available on Amazon November 24. eben On Sun, Nov 14, 2010 at 12:49 PM, Aaron Morton wrote: > The Cassandra book is still listed as unpublished on Amazon > http://amzn.com/14493

Re: Cassandra with Web2Py

2010-11-14 Thread Tyler Hobbs
Dipti, I noticed that web2py supports using Google App Engine. Since GAE's data model is close to Cassandra's, it might not be too hard to add similar support. I'm the current maintainer for pycassa, so if you're interested in adding Cassandra support to web2py, let me know and maybe we can work

Re: repair takes two days, and ends up stuck: stream at 1096% (yes, really)

2010-11-14 Thread Jonathan Ellis
What exception is causing it to fail/retry? On Sun, Nov 14, 2010 at 3:49 PM, Chip Salzenberg wrote: > My by-now infamous eight-node cluster running 0.7.0beta3+ dropped many > replication MUTATEs during load, so I decided to fix replication copies with > a "nodetool repair" on one of the nodes (X.

repair takes two days, and ends up stuck: stream at 1096% (yes, really)

2010-11-14 Thread Chip Salzenberg
My by-now infamous eight-node cluster running 0.7.0beta3+ dropped many replication MUTATEs during load, so I decided to fix replication copies with a "nodetool repair" on one of the nodes (X.21). The repair has been running for two days, and has finally gotten itself wedged into a state where it c

Re: Cassandra with Web2Py

2010-11-14 Thread Dipti Mathur
Thanks Aaron, That's just what I am doing. Using pycassa in place of the standard modules. It's getting sort of cumbersome though. Thanks for your help! Now the effort seems worth it - since there is no easier option! -Dipti On Mon, Nov 15, 2010 at 12:59 AM, Aaron Morton wrote: > I've not seen

Cassandra: The Definitive Guide

2010-11-14 Thread Aaron Morton
The Cassandra book is still listed as unpublished on Amazon http://amzn.com/1449390412 But it's no longer listed as Rough Cuts on the Safari site http://my.safaribooksonline.com/9781449399764Aaron

Re: Cassandra with Web2Py

2010-11-14 Thread Aaron Morton
I've not seen anyone talking about it, nor seen it myself.I just took a look at the docs for the Database Abstraction Layer here http://web2py.com/book/default/chapter/06 It seems to be focused on RDBMS back ends and standard SQL. E.g. it has support for transactions, executing raw SQL and creating

Re: HowTo: Range scan on secondary indexes?

2010-11-14 Thread André Fiedler
Ah ok, so i have to build a hash index to get all relevant data sets first, than cassa performs the range scan. Good to know, thx a lot! :o) 2010/11/14 Jonathan Ellis > Because 0.7.0 indexes are more like a Hash index than a B-tree. > > On Sun, Nov 14, 2010 at 12:39 PM, André Fiedler > wrote:

Re: Secondary index query return row should not return?

2010-11-14 Thread Jonathan Ellis
https://issues.apache.org/jira/browse/CASSANDRA-1745 On Thu, Nov 11, 2010 at 2:49 PM, Jonathan Ellis wrote: > It's working as written, but I think you're right that it makes more > sense to fail the expression when the column doesn't exist. > > On Thu, Nov 11, 2010 at 7:04 AM, Ching-Cheng Chen >

Re: HowTo: Range scan on secondary indexes?

2010-11-14 Thread Jonathan Ellis
Because 0.7.0 indexes are more like a Hash index than a B-tree. On Sun, Nov 14, 2010 at 12:39 PM, André Fiedler wrote: > Ok, i read this before. Could you explain (short) why i have to do this? In > my opinion it isn't necessary, i want to understand why it is. ;o) > thx André! > > 2010/11/14 Nat

Re: HowTo: Range scan on secondary indexes?

2010-11-14 Thread André Fiedler
Ok, i read this before. Could you explain (short) why i have to do this? In my opinion it isn't necessary, i want to understand why it is. ;o) thx André! 2010/11/14 Nate McCall > You must have a clause with an EQ operator on an indexed column present. > See: > http://wiki.apache.org/cassandra/A

Re: HowTo: Range scan on secondary indexes?

2010-11-14 Thread Nate McCall
You must have a clause with an EQ operator on an indexed column present. See: http://wiki.apache.org/cassandra/API07#IndexClause and: http://wiki.apache.org/cassandra/API07#get_indexed_slices For more details. On Sun, Nov 14, 2010 at 12:09 PM, André Fiedler wrote: > Hi, i wrote a question on t

HowTo: Range scan on secondary indexes?

2010-11-14 Thread André Fiedler
Hi, i wrote a question on the phpcassa group, but i think its more cassandra related. Would be nice, if you get some time and take a look: http://groups.google.com/group/phpcassa/browse_thread/thread/1b6acb5f7dccb94f greetings André

Re: using SimpleAuthenticator is not working

2010-11-14 Thread Eric Evans
On Fri, 2010-11-12 at 17:07 -0800, Alaa Zubaidi wrote: > using SimpleAuthenticator is not working with me in beta 3 > > I am doing the following: > > ·In Cassandra.yaml Set > authenticator: org.apache.cassandra.auth.SimpleAuthenticator > ·Add username and password to passwd.proprties > ·Add usern

Cassandra with Web2Py

2010-11-14 Thread Dipti Mathur
Hi, Is anyone using Cassandra with web2py framework? Is there a DAL that can directly be specified in the db.py module? Without this the login module and similar functionalities provided by web2py cannot be used. Thanks, Dipti Mathur

Re: Rows missing after new node bootstrapped

2010-11-14 Thread Jonathan Ellis
Are you using a version with working range scans? On Sat, Nov 13, 2010 at 6:11 PM, Christian Decker wrote: > Hi all, > > I'm having some doubts about the current state of my cluster. I started with > one node, filled it with some 10 million rows, then flushed and compacted > the node. Then I ran

Re: Rows in decreasing order

2010-11-14 Thread Jonathan Ellis
As you may have guessed from the lack of a "reversed" option on the range slice api, backward scans are not supported. The standard thing to do is load the keys you are interested in as columns to a row. On Sat, Nov 13, 2010 at 3:33 PM, Casey Deccio wrote: > Hi, > > I'm working with Cassandra 0.