indexes in cassandra

2011-01-23 Thread Shay Assulin
hi, I am using get_indexed_slices to get rows from Cassandra Does Cassandra returns the rows with some order? I am using OPP and it seems that the rows are ordered 10x

Re: Does Cassandra support range queries on keys ?

2011-01-23 Thread Peter Schuller
> I'm new to dynamo. I'm looking to implement something similar to prefix > search for keys (much like S3 allows you to list all the keys that match a > certain prefix). > Can I implement this with Cassandra? I'm using Hector as the client but > would gladly go thrift is necessary. Range queries o

Ring up but read fails ...

2011-01-23 Thread cbert...@libero.it
Hi all, I build a java webapp using Cassandra as DB. At the startup the application creates a cassandra pool using the Pelops client ... it my dev and test environment everything works but in production I have some strange problems. So I built a JSP to check the status of Cassandra DB, doing noth

Re: Does Cassandra support range queries on keys ?

2011-01-23 Thread Maxim Veksler
Thank you Peter. Following your suggestions, of using key of super column as range token won't I have a storage problem? I couldn't find information about this so I'll just ask: If I have a (Super/)ColumnFamily that contains 1 "key" for the row but that row contains millions of k:v entries. Would

Re: Lost MUTATIONS on several Cassandra nodes - no impact on the client

2011-01-23 Thread ruslan usifov
2011/1/20 Jonathan Ellis > > It guarantees that if the requested ConsistencyLevel is not achieved, > client will get a TimedOutException, which is a signal you need to add > capacity to handle what you are throwing at the cluster. > > Sorry and when UnavailableException is thows? When data can't

Re: Ring up but read fails ...

2011-01-23 Thread ruslan usifov
2011/1/23 cbert...@libero.it > > ERROR UserNameCmd:38 - java.net.SocketException: Broken pipe > ERROR UidCmd:61 - java.net.SocketException: Broken pipe > org.apache.thrift.transport.TTransportException: java.net.SocketException: > Broken pipe > ... > at > org.apache.cassandra.thrift.Cassandra$Cl

Re: Lost MUTATIONS on several Cassandra nodes - no impact on the client

2011-01-23 Thread Edward Capriolo
On Sun, Jan 23, 2011 at 6:30 AM, ruslan usifov wrote: > > > 2011/1/20 Jonathan Ellis >> >> It guarantees that if the requested ConsistencyLevel is not achieved, >> client will get a TimedOutException, which is a signal you need to add >> capacity to handle what you are throwing at the cluster. >>

Re: Ring up but read fails ...

2011-01-23 Thread Jake Luciani
I've seen this when you leave a socket open and idle for a long time. The connection times out. On Jan 23, 2011, at 8:42 AM, ruslan usifov wrote: > > > 2011/1/23 cbert...@libero.it > > ERROR UserNameCmd:38 - java.net.SocketException: Broken pipe > ERROR UidCmd:61 - java.net.SocketExcept

R: Re: Ring up but read fails ...

2011-01-23 Thread cbert...@libero.it
> I've seen this when you leave a socket open and idle for a long time. The > connection times out. It could be the situation ... any idea about the solution?I create the pool once at startup and rely on this ... > Perhaps you use wrong transport in Thrift. Which version of cassandra you use? C

Re: Lost MUTATIONS on several Cassandra nodes - no impact on the client

2011-01-23 Thread ruslan usifov
On Sun, Jan 23, 2011 at 6:30 AM, ruslan usifov > wrote: > > Right. The difference is that the gossip process builds a topology of > UP/DOWN hosts so Unavailable is thrown quickly. If you need ALL and > one replica is known down -> Unavailable. > > Is it possible to detect that write doesn't happen

Re: Lost MUTATIONS on several Cassandra nodes - no impact on the client

2011-01-23 Thread Edward Capriolo
On Sun, Jan 23, 2011 at 11:23 AM, ruslan usifov wrote: > > > >> On Sun, Jan 23, 2011 at 6:30 AM, ruslan usifov >> wrote: >> >> Right. The difference is that the gossip process builds a topology of >> UP/DOWN hosts so Unavailable is thrown quickly. If you need ALL and >> one replica is known down

Re: R: Re: Ring up but read fails ...

2011-01-23 Thread Jake Luciani
Reconnect and try again? On Jan 23, 2011, at 10:47 AM, "cbert...@libero.it" wrote: > > I've seen this when you leave a socket open and idle for a long time. The > > connection times out. > > It could be the situation ... any idea about the solution? > I create the pool once at startup and

Re: Java cient

2011-01-23 Thread Nate McCall
We are always looking for recommendations on API usage as well. If helpful, there is a PDF document available on Hector: http://www.datastax.com/sites/default/files/hector-v2-client-doc.pdf As well as an example twitter clone example web app using Hector and Wicket: https://github.com/riptano/twi

R: Re: R: Re: Ring up but read fails ...

2011-01-23 Thread cbert...@libero.it
> Reconnect and try again? Sorry what do you mean by "Reconnect and try again?" -- You mean to shut down the old pool and create a new pool of connections?I don't have the possibility to handle the single connection using Pelops ... >From Dominic Williams Blog "To work with a Cassandra cluster,

Re: Cassandra taking 100% cpu over multiple cores(0.7.0)

2011-01-23 Thread Erik Onnen
One of the developers will have to confirm but this looks like a bug to me. MessagingService is a singleton and there's a Multimap used for targets that isn't accessed in a thread safe manner. The thread dump would seem to confirm this, when you hammer what is ultimately a standard HashMap with mu

Re: Cassandra taking 100% cpu over multiple cores(0.7.0)

2011-01-23 Thread Erik Onnen
Filed as https://issues.apache.org/jira/browse/CASSANDRA-2037 I can't see how the code would be correct as written but I'm usually wrong about most things. On Sun, Jan 23, 2011 at 12:14 PM, Erik Onnen wrote: > One of the developers will have to confirm but this looks like a bug > to me. Messagin

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread Aaron Morton
Timo / Maxim Could you provide a more concrete example and I'll try to look into it tonight. Cheers Aaron On 22/01/2011, at 5:01 AM, Maxim Potekhin wrote: > Well it does sound like a bug in Cassandra. Indexes MUST commute. > > I really need this functionality, it's a show stopper for me... >

Errors During Compaction

2011-01-23 Thread Dan Hendry
I have run into a strange problem and was hoping for suggestions on how to fix it (0.7.0). When compaction occurs on one node for what appears to be one specific column family, the following error pops up the Cassandra log. Compaction apparently fails and temp files don't get cleaned up. After a wh

Re: indexes in cassandra

2011-01-23 Thread Jonathan Ellis
They are returned in token order, which is the same as key order for OPP. On Sun, Jan 23, 2011 at 2:11 AM, Shay Assulin wrote: > > hi, > > I am using get_indexed_slices to get rows from Cassandra > Does Cassandra returns the rows with some order? I am using OPP and it seems > that the rows are or

Re: How does Bootstrapping work in 0.7 ??

2011-01-23 Thread Patrick de Torcy
Thanks, Eric and Peter, for all the replies ! It helped me a lot... I've read again the Getting Started page... In fact I have particularly read the chapter : "setting up a multi node cluster" (as it was what I tried to do). It's written : "T

Re: indexes in cassandra

2011-01-23 Thread Maxim Potekhin
Jonathan, what's your comment to the other thread, where the developers state that indices do not commute? On 1/23/2011 4:30 PM, Jonathan Ellis wrote: They are returned in token order, which is the same as key order for OPP. On Sun, Jan 23, 2011 at 2:11 AM, Shay Assulin wrote: hi, I am usi

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread Maxim Potekhin
Aaron -- thanks! I don't have examples like Timo. But, I'm keen to use multiple indices over a database of 300M rows. Maxim On 1/23/2011 3:28 PM, Aaron Morton wrote: Timo / Maxim Could you provide a more concrete example and I'll try to look into it tonight. Cheers Aaron On 22/01/2011,

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread David McNelis
Silly question, M us thousand or million? In print, thousand is M, fwiw Sent from my Droid On Jan 23, 2011 7:26 PM, "Maxim Potekhin" wrote: > Aaron -- thanks! > > I don't have examples like Timo. > > But, > > I'm keen to use multiple indices over a database > of 300M rows. > > > Maxim > > > On 1

Re: Re: R: Re: Ring up but read fails ...

2011-01-23 Thread Dan Washusen
This is a known issue with the Cassandra 0.6 versions of Pelops. The issue was fixed in the 0.7 based versions a few months ago but never back-ported (Dominic, myself and the other contributors don't run 0.6)... On 24 January 2011 05:25, cbert...@libero.it wrote: > > Reconnect and try again? >

[RELEASE] 0.6.10

2011-01-23 Thread Eric Evans
There hasn't been a bunch going on in this branch since the last release (that was less than 2 weeks ago after all), but the fix for CASSANDRA-1959[1] seemed important enough to warrant an 0.6.10. As usual, links to source and binary archives are available from the Downloads page[3], and packages

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread Maxim Potekhin
Not silly at all, sorry for eschewing clarity in Latin usage: millions, not thousands. Here in the States, we typically use M for millions. Anyhow, my system generates 1 million (large) records every three days, Cheers, Maxim On 1/23/2011 8:35 PM, David McNelis wrote: Silly question, M us

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread David McNelis
No worries, I am in the states too. Sent from my Droid On Jan 23, 2011 8:05 PM, "Maxim Potekhin" wrote: > Not silly at all, sorry for eschewing clarity in Latin usage: > > millions, not thousands. > > Here in the States, we typically use M for millions. > Anyhow, my system generates 1 million (la

about the partitioner type

2011-01-23 Thread raoyixuan (Shandy)
whether the random/order partitioner specify the token for the node ,not for key? 华为技术有限公司 Huawei Technologies Co., Ltd.[Company_logo] Phone: 28358610 Mobile: 13425182943 Email: raoyix...@huawei.com 地址：深圳市龙岗区坂田华为基地 邮编：518129 Huawei Technologies Co., Ltd. Bantian

Re: about the partitioner type

2011-01-23 Thread Tyler Hobbs
http://www.datastax.com/docs/0.7/operations/clustering#tokens-partitioners-and-the-ring - Tyler 2011/1/23 raoyixuan (Shandy) > whether the random/order partitioner specify the token for the node > ,not for key? > > > > 华为技术有限公司 Huawei Technologies Co., Ltd.[image: Company_logo] > > > > > > >

RE: about the partitioner type

2011-01-23 Thread raoyixuan (Shandy)
How to compare the key itself (as a byte array) to the tokens in the ring in OrderPreservingPartitioner? As in know, the node which value is larger than key value will handle the key in random partitioner From: Tyler Hobbs [mailto:ty...@riptano.com] Sent: Monday, January 24, 2011 11:43 AM To: us

Invalid token errors when all nodes appear to have tokens.

2011-01-23 Thread Todd Nine
Hi all, I'm getting some strange invalid token errors. I'm on Cassandra 0.7.0. Using the JMX console, each node has a valid token. Also, each node shows as a live node in the cluster. Any ideas why I'm getting this error? I've restarted the entire cluster and I can't seem to resolve the pro

Re: Invalid token errors when all nodes appear to have tokens.

2011-01-23 Thread Jonathan Ellis
It sure seems to think it's using OPP and not BOP... On Sun, Jan 23, 2011 at 11:22 PM, Todd Nine wrote: > Hi all, >   I'm getting some strange invalid token errors.   I'm on Cassandra 0.7.0. > Using the JMX console, each node has a valid token.   Also, each node shows > as a live node in the clus

Re: Invalid token errors when all nodes appear to have tokens.

2011-01-23 Thread Todd Nine
Gah! I can't believe I missed that. I had 2 nodes that didn't have updated attributes in chef. They were using my old config with OrderPreservingPartitioner. Thanks for the help man, been starting at this one for way too long. On 24 January 2011 18:46, Jonathan Ellis wrote: > It sure seems t