Is it possible to query using wildcards in cassandra 0.7?

Hi all, I really like the second index feature that has been added to 0.7 release. My question is, Is it possible to query using wildcards in cassandra 0.7? Thanks for the insights. Kind regards, Joshua. -- http://twitter.com/jpartogi

Re: Memory leak with Sun Java 1.6 ?

Didn't have time yet to properly respond to this one, but check out the "Very high memory utilization (not caused by mmap on sstables)" thread from today. You're using the same Ubuntu/JVM, right? Seems to match your observations. (Sorry no ML archive link; the ML archives for Apache projects has n

Re: [SOLVED] Very high memory utilization (not caused by mmap on sstables)

> Sorry for spam again. :-) No, thanks a lot for tracking that down and reporting details! Presumably a significant amount of users are on that version of Ubuntu running with openjdk. -- / Peter Schuller

Re: Memory leak with Sun Java 1.6 ?

Hi Peter, I've read through the "Very high memory utilization (not caused by mmap on sstables)" and the impact sounds similar .. alas they're using openJDK and I'm using Sun's. Of course, it's not impossible that the same bug is present in both JVM's. j.

Re: Too many open files Exception + java.lang.ArithmeticException: / by zero

I increased the amount of the allowed file descriptors to "unlimted". Now, I get exactly the same exception after 3.50 rows : *CustomTThreadPoolServer.java (line 104) Transport error occurred during acceptance of message.* *org.apache.thrift.transport.TTransportException: java.net.SocketExcept

Re: Too many open files Exception + java.lang.ArithmeticException: / by zero

Be careful with the unlimited value on ulimit, you could end up with a unresponsive server... I mean, you could not even connect via ssh if you don't have enough handles. On Thu, Dec 16, 2010 at 9:59 AM, Amin Sakka, Novapost < amin.sa...@novapost.fr> wrote: > > I increased the amount of the allow

Re: Memory leak with Sun Java 1.6 ?

This bug is present in both Sun JDK and open JDK because they share the same hotspot VM. Sun JDK got the fix earlier than open JDK. best regards, hanzhu On Thu, Dec 16, 2010 at 6:43 PM, Jedd Rashbrooke < jedd.rashbro...@imagini.net> wrote: > Hi Peter, > > I've read through the "Very high memo

Re: Too many open files Exception + java.lang.ArithmeticException: / by zero

how many sstable "Data.db" files do you see in your system and how big are they? Also, how big are the rows you are inserting? On Thu, Dec 16, 2010 at 7:59 AM, Amin Sakka, Novapost < amin.sa...@novapost.fr> wrote: > > I increased the amount of the allowed file descriptors to "unlimted". > Now,

Streaming Row Ranges

Hi In order to access all rows in Cassandra a common pattern is to do multiple range scans and page through them, starting with the last key from the previous result. This introduces a lot of (unnecessary) latency. As the client has to read the result extract the last key and start a new query

Re: batch mutate with only deletions on 0.7beta2

There are a couple of .NET clients listed on the wiki. Aquiles particularly seems to be getting a lot of attention recently: http://aquiles.codeplex.com/ Unless you have a specific use case (or are just experimenting) it's best to avoid raw Thrift and make use of an existing library so you do not

Re: Too many open files Exception + java.lang.ArithmeticException: / by zero

Are you creating a new connection for each row you insert (and if so are you closing it)? -ryan On Wed, Dec 15, 2010 at 8:13 AM, Amin Sakka, Novapost wrote: > Hello, > I'm using cassandra 0.7.0 rc1, a single node configuration, replication > factor 1, random partitioner, 2 GO heap size. > I ran

RE: cassandra database viewer

You could also try http://cassui.googlecode.com -Sanjay From: Shashank Tiwari [mailto:tsha...@gmail.com] Sent: Saturday, December 11, 2010 4:01 AM To: user@cassandra.apache.org Subject: Re: cassandra database viewer what about https://github.com/suguru/cassandra-webconsole? any good? On Fri, De

Re: Too many open files Exception + java.lang.ArithmeticException: / by zero

I'm using a unique client instance (using Hector) and a unique connection to cassandra. For each insertion I'm using a new mutator and then I release it. I have 473 sstable "Data.db", the average size of each is 30Mo. 2010/12/16 Ryan King > Are you creating a new connection for each row you

Re: Too many open files Exception + java.lang.ArithmeticException: / by zero

You probably want to switch to using mutator#addInsertion for some number of iterations (start with 1000 and adjust as needed), then calling execute(). This will be much more efficient. On Thu, Dec 16, 2010 at 11:39 AM, Amin Sakka, Novapost wrote: > > I'm using a unique client instance (using Hec

Re: Too many open files Exception + java.lang.ArithmeticException: / by zero

Indeed Hector has a connection pool behind it, I think it uses 50 connectios per node. But also uses a node to discover the others, I assume that, as I saw connections from my app to nodes that I didn't configure in Hector. So, you may check the fds in OS level to see if there is a bottleneck ther

Re: Too many open files Exception + java.lang.ArithmeticException: / by zero

Ya, that happens when some operation throws a time out or any other sort of operation (connection refuse, etc). There is a failback logic that will try to discover all the nodes within the Cluster (not only the ones you configured) in order to reach the cluster and execution the operation. Have y

Re: Is it possible to query using wildcards in cassandra 0.7?

Short answer: no. Longer answer: not yet. On Thu, Dec 16, 2010 at 1:59 AM, Joshua Partogi wrote: > Hi all, > > I really like the second index feature that has been added to 0.7 release. > My question is, Is it possible to query using wildcards in cassandra 0.7? > > Thanks for the insights. > > K

Installing Cassandra on windows

Hi there, I am trying to install Cassandra on windows.. I have downloaded the files and when I try to connect to the cassandra through command prompt I get an error: *java.net connection exception: Connection refused *I have set the environment variables properly & pointed to my JDK installatio

Re: Installing Cassandra on windows

You are trying to connect through cassandra-cli? Does the cassandra log indicate it started correctly? Can you hit port 9160 (telnet localhost 9160)? On Thu, Dec 16, 2010 at 2:34 PM, Rajkumar Gupta wrote: > > Hi there, > > I am trying to install Cassandra on windows.. I have downloaded the files

Re: Streaming Row Ranges

> I think that, from a client perspective it would be nicer in many scenarios > just to “ask for all rows in a cf” and to receive some kind of stream and > read the rows one by one from that stream instead of receiving all rows and > then iterating over them (and being limited by the count of rows)

Re: Installing Cassandra on windows

yes I tried to connect through: *cassandra-cli -host localhost -9160* It gave me the error *java.net.connection exception: Connection refused* but still says: "Welcome to Cassandra CLI". When I try to see the name of cluster by show, it says not connected to a cassandra instance On Fri, Dec

Re: Installing Cassandra on windows

just tried my self seems to be that you are not starting the cassandra process first the cli is only to access it, not to start it execute cassandra first Nicolas Santini On Fri, Dec 17, 2010 at 9:55 AM, Rajkumar Gupta wrote: > yes I tried to connect through: > > *cassandra-cli -host localhost

Read Latency Degradation

We are running .6.8 and are reaching 1tb/node in a 10 node cluster rf=3. Our reads times seem to be getting worse as we load data into the cluster, and I am worried there is a scale problem in terms of large column families. All benchmarks/times come from cfstats reporting so no client code or time

Re: Read Latency Degradation

On Thu, Dec 16, 2010 at 2:35 PM, Wayne wrote: > I have read that read latency goes up with the total data size, but to what > degree should we expect a degradation in performance? I'm not sure this is generally answerable because of data modelling and workload variability, but there are some kno

Re: Read Latency Degradation

On Thu, Dec 16, 2010 at 7:15 PM, Robert Coli wrote: > On Thu, Dec 16, 2010 at 2:35 PM, Wayne wrote: > >> I have read that read latency goes up with the total data size, but to what >> degree should we expect a degradation in performance? > > I'm not sure this is generally answerable because of da

Re: Installing Cassandra on windows

Thanks a ton Nicolas! This helped..its working now :) Can you also tell me where to keep the cassandra folder with phpcassa to use it with wamp server.. Thanks for your great help!! Regards Rajkumar On Fri, Dec 17, 2010 at 2:31 AM, Nick Santini wrote: > just tried my self > seems to be that you