Re: Creating secondary index CQL3 cassandra 1.1.1

On Thu, Jun 21, 2012 at 5:11 AM, Stephen Powis stephen.po...@pardot.com wrote: I have the following schema: describe columnfamily visitor_audit; CREATE TABLE visitor_audit (   visitor_id text,   audit_id uuid,   account_id int,   audit_type int,   created_at text,   PRIMARY KEY

Re: When will CQL BATCH support binding variable (Query substitution use named parameters)?

On Thu, Jun 21, 2012 at 12:06 AM, Data Craftsman database.crafts...@gmail.com wrote: Hello, CQL BATCH is good for INSERT/UPDATE performance. But it cannot do binding variable, exposed to SQL injection. Is there a plan to make CQL BATCH to support binding variable in near future? e.g.

Re: cqlsh commands

You should be able to get most of this information from the datastax documentation, e.g. http://www.datastax.com/docs/1.0/references/cql/index for version 1.0. Jeff On Jun 20, 2012, at 1:47 PM, Thierry Templier wrote: Hello, I'm using cqlsh tool to create column families and it works

Tiered compation on two disks

Hi, I have a Cassandra installation where we plan to store 1Tb of data, split between two 1Tb disks. Tiered compation should be better suited for our workload (append-only, deletion of old data, few reads). I know that tiered compaction needs 50% free disk space for worst case situation. How

Starting cassandra with -D option

Hi Folks, We wanted to have a single cassandra installation, and use it to start cassandra in other nodes by passing it the cassandra configuration directories as a parameter. Idea is to avoid having the copies of cassandra code in each node, and starting each node by getting into

Re: Starting cassandra with -D option

The option must actually include also the name of the yaml file: Dcassandra.config=file:///Users/walmart/Downloads/Cassandra/Node2-Cassandra1.1.0/conf/cassandra.yaml Flavio Il 6/21/2012 13:16 PM, Roshni Rajagopal ha scritto: Hi Folks, We wanted to have a single cassandra installation,

Re: cqlsh commands

What do you mean when you say you can't display the related documentations using the help command? What does cqlsh do instead? I don't know about any bugs in that area. p On Wed, Jun 20, 2012 at 6:47 AM, Thierry Templier thierry.templ...@restlet.com wrote: Hello, I'm using cqlsh tool to

Strange behavior ¿data corruption?

Hi I'm using version 1.1.1. I'm sorry about the lack of information, i don't have stacktraces, nothig crash, just return empty, i explain, i do login as usual, find in db if there is a user named X and who belongs to client Y, if that is true i return the hash of password from db and do my

Re: Using row cache causes slowdown and unavailable reads

2300 * 5MB / 1024 = 11GB Check the logs for GC problems. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 20/06/2012, at 8:39 PM, Nury Redjepow wrote: Good day, I'm load testing our cassandra instance. I have a column family with

Re: Unbalanced ring in Cassandra 0.8.4

Does cleanup only cleanup keys that no longer belong to that node. Yes. I guess it could be an artefact of the bulk load. It's not been reported previously though. Try the cleanup and see how it goes. Cheers - Aaron Morton Freelance Developer @aaronmorton

RE: Much more native memory used by Cassandra then the configured JVM heap size

Just to close this item: with CASSANDRA-4314 applied I see no memory errors (either Java heap or native heap). Cassandra appears to be a hog with its memory mapped files. This caused us to wrongly think it was the culprit in a severe native memory leak. However, our leaky process was a

Re: Creating secondary index CQL3 cassandra 1.1.1

Ah yes that's it exactly, including the time outs/errors. I wonder why this didn't come up when I googled the error from my system logs. Thanks! Stephen On Thu, Jun 21, 2012 at 2:47 AM, Sylvain Lebresne sylv...@datastax.comwrote: On Thu, Jun 21, 2012 at 5:11 AM, Stephen Powis

Indexing JSON in Cassandra

I know we had this conversation over on the dev list a while back: http://www.mail-archive.com/dev@cassandra.apache.org/msg03914.html I just wanted to let people know that we added the capability to our cassandra-indexing extension.

Re: Much more native memory used by Cassandra then the configured JVM heap size

We run some fairly large and busy Cassandra setups. All of them without mmap. I have yet to see a benchmark which conclusively can say mmap is better (or worse for that matter) than standard ways of doing I/O and we have done many of them last 2 years by different people, with different tools

Cassandra 1.0.6 data flush query

Hi I am using Cassandra 1.0.6 version in our production system and noticed that Cassandra flushing the data to SSTable and the file size is 10MB. With under moderate write load, the Cassandra flushing lots of memtables with small sizes. With this compaction doing lots of compactions. O/S -