Re: Last Modified Time Series in cassandra

2012-12-23 Thread Ravikumar Govindarajan
I can append timeuuid on every update and resolve conflicts on read to support time series data on last-modified-time. Ex: -- ExampleCF | -- SomeKey = Key | -- TimeUUIDNew = Column-Name | -- PKID = Column-Value .. | -- TimeUUIDOld = Column

Re: CQL3 Compound Primary Keys - Do I have the right idea?

2012-12-23 Thread Tristan Seligmann
On Sun, Dec 23, 2012 at 9:25 PM, aaron morton wrote: > In this example: > > CREATE TABLE seen_ships ( >day text, >time_seen timestamp, >shipname text, >PRIMARY KEY (day, time_seen) >); > http://www.datastax.com/dev/blog/whats-new-in-cql-3-0 > > * day is the int

Re: CQL3 Compound Primary Keys - Do I have the right idea?

2012-12-23 Thread Pierre-Yves Ritschard
Yup, this is pretty explicit when listing from the cli. Great to know that composite row keys are "coming", lookikng forward to it On Sun, Dec 23, 2012 at 8:25 PM, aaron morton wrote: > Agreed. I actually flip between cli and cqlsh these days. >> > Only tables created with COMPACT STORAGE are v

CQLSH select time series data, bug?

2012-12-23 Thread Karl Hiramoto
Hi, I get what looks like a python error "'float' object has no attribute 'replace'" from cqlsh with the version packaged in version 1.1.8 $ ./apache-cassandra-1.1.8/bin/cqlsh Connected to Test Cluster at localhost:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 2.0.0 | Thrift protocol 19.3

Re: Cassandra read throughput with little/no caching.

2012-12-23 Thread aaron morton
First, the non helpful advice, I strongly suggest changing the data model so you do not have 100MB+ rows. They will make life harder. > Write request latency is about 900 microsecs, read request > latency > is about 4000 microsecs. > > 4 milliseconds to

Re: Exception on running nodetool in windows

2012-12-23 Thread aaron morton
The line numbers in the stack trace do not match the code for 1.1.6. I would blow away the install and check your java install. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 22/12/2012, at 6:59 PM, Vivek Mishra w

Re: Need to run nodetool repair on a cluster running 1.1.6 if no deletes

2012-12-23 Thread aaron morton
> I'm seeing some conflicting advice out there about whether you need to run > nodetool repair within GCGraceSeconds with 1.x. Can someone clarify two > things: Can you point me to the advice not to run it. > (1) Do I need to run repair if I'm running 1.x? Yes. Repair / Anti Entropy needs to b

Re: CQL3 Compound Primary Keys - Do I have the right idea?

2012-12-23 Thread aaron morton
> Agreed. I actually flip between cli and cqlsh these days. Only tables created with COMPACT STORAGE are visible to cassandra-cli (in fact visible to any thrift based client). This article helps http://www.datastax.com/dev/blog/cql3-for-cassandra-experts > Is there still a way to have composit

Re: how to create a keyspace in CQL3

2012-12-23 Thread Edward Capriolo
Unfortunately one of the first command everyone needs to use to use to work with cassandra changes very often. You can use cqlsh> help create_keyspace; But some times even the documentation is not in line. Using this permutation of goodness: cqlsh 2.3.0 | Cassandra 1.2.0-beta2-SNAPSHOT | CQL s

Re: State of Cassandra and Java 7

2012-12-23 Thread Edward Capriolo
This what versions are supported is kinda up to you for example earlier versions of jdk now have bugs. I have a version of java 1.6.0_23 I believe that will not even start with the latest cassandra releases. Likewise people suggest not running the newest ones 1.7.0 because they have not tested it.

Re: State of Cassandra and Java 7

2012-12-23 Thread Fabrice Facorat
At Orange portails we are presently testing Cassandra 1.2.0 beta/rc with Java 7, and presnetly we have no issues 2012/12/22 Brian Tarbox : > What I saw in all cases was > a) set JAVA_HOME to java7, run program fail > b) set JAVA_HOME to java6, run program success > > I should have better notes but