Re: Double ColumnType and comparing

There is nothing in the 0.8 trunk to add double support. Could you shift the decimal point and use ints / longs ? Double is not a precise type, so there is a possibility of the value changing as it's serialised and deserialised around. You were on the right track with extending abstract type.

Re: Can the Cassandra to be hosted, with all your features and performance, on Microsoft Azure ?

If it works like all the other virtual machine hosts then yes it can be hosted. Performance can always be less on a virtual machine though. See http://wiki.apache.org/cassandra/CloudConfig Aaron On 14 Mar 2011, at 13:09, FernandoVM wrote: > Hello friends, > > > Anyone know if the Cass

Re: get_range_slices perf

What are you using for the SlicePredicate with get_range_slices() ? What sort of performance are you getting for each request (client and server side)? Even if you are asking for zero columns, there is still a lot of work to be done when performing a range scan. e.g. Each SSTable must be checke

Re: Secondary indices: Why low cardinality?

On Thu, Mar 10, 2011 at 10:43 PM, Kevin wrote: > > Can someone explain why low cardinality is advised for the secondary index? The brief answer to your question is "because it is a local secondary index." https://issues.apache.org/jira/browse/CASSANDRA-749 Has a pretty thorough discussion of wh

Double ColumnType and comparing

I am quite new to Cassandra and am trying to model a simple Column Family which uses Doubles as column names: Datalines: { // ColumnFamilly dataline-1:{ // row key 23.5: 'someValue', 23.6: 'someValue', ... 4334.99: 'someValue' }, dataline-2:{ 10.5: 'someValue', 12.6: 'someValue', ..

Can the Cassandra to be hosted, with all your features and performance, on Microsoft Azure ?

Hello friends,      Anyone know if the Cassandra can be hosted, with all your features and performance, on Microsoft Azure? []'s FernandoVM

get_range_slices perf

Hey all, I'm trying to get a list of all the rows from a column family using get_range_slices retrieving no actual columns. I expected this operation to be pretty quick, but it seems to take a while (5-node 0.7.0 cluster takes 20 min to page through 60k keys 1000 at a time). It's not completely

Re: Strange error

2011/3/14 aaron morton > What sort of workload was that ? All read and write or could there have > been some deletes as well? > Many reads, some writes, and some deletes

Re: Strange error

What sort of workload was that ? All read and write or could there have been some deletes as well? Aaron On 14 Mar 2011, at 10:06, ruslan usifov wrote: > > > 2011/3/14 aaron morton > Looks related to CASSANDRA-1559 > https://issues.apache.org/jira/browse/CASSANDRA-1559 which should be fixed

Re: Strange error

2011/3/14 aaron morton > Looks related to CASSANDRA-1559 > https://issues.apache.org/jira/browse/CASSANDRA-1559 which should be fixed > in 0.7.4 > > However everyone > said it should not happen. Can you provide some more detail about what you

Re: Strange behaivour

2011/3/13 aaron morton > It's difficult to say what's causing the freeze. > > Was the node rejecting client connections during this time ? > Yes. I think that hung all java because jmx doesn't respond too > Did any of the other nodes log that the node that was freezing was down ? > Yes > Is

Re: Strange error

Looks related to CASSANDRA-1559 https://issues.apache.org/jira/browse/CASSANDRA-1559 which should be fixed in 0.7.4 However everyone said it should not happen. Can you provide some more detail about what you did to cause this to happen. Aaron On 14 Mar 2011, at 06:47, ruslan usifov wrote: >

Re: reducing disk usage advice

On 3/13/2011 9:27 PM, aaron morton wrote: The CF Stats are reporting you have 70GB total space taken up by SSTables, of which 55GB is live. The rest is available for deletion, AFAIK this happens when cassandra detects free space is running low. I've never dug into how/when this happens though.

Re: Strange behaivour

It's difficult to say what's causing the freeze. Was the node rejecting client connections during this time ? Did any of the other nodes log that the node that was freezing was down ? Is there anything else running on the box? Aaron On 14 Mar 2011, at 07:02, ruslan usifov wrote: > Hello > >

Re: reducing disk usage advice

The CF Stats are reporting you have 70GB total space taken up by SSTables, of which 55GB is live. The rest is available for deletion, AFAIK this happens when cassandra detects free space is running low. I've never dug into how/when this happens though. With that amount of data it seems odd to

reducing disk usage advice

Hi, I'm looking for advice on reducing disk usage. I've ran out of disk space two days in a row while running a nightly scheduled nodetool repair && nodetool compact cronjob. I have 6 nodes RF=3 each with 300 GB drives at a hosting company. GCGraceSeconds= 26 (3.1 days) Every colu

Re: Is it possible to get just a count of the no of columns in a row, in efficient manner ?

On Sun, Mar 13, 2011 at 7:07 AM, Ertio Lew wrote: > Can I get just a count of the no of columns in a row without > deserializing all columns in row? No. > Or should the usage of a counter > column be preferred that maintains the no of columns currently present > in the row, for the situations

Strange error

Hello in working cluster of cassandra 0.7.3 in system.log i see 2 simular errors: ERROR [ReadStage:12] 2011-03-13 20:27:20,431 AbstractCassandraDaemon.java (line 114) Fatal exception in thread Thread[ReadStage:12,5,m ain] java.lang.NullPointerException at org.apache.cassandra.db.Column.rec

Is it possible to get just a count of the no of columns in a row, in efficient manner ?

Can I get just a count of the no of columns in a row without deserializing all columns in row? Or should the usage of a counter column be preferred that maintains the no of columns currently present in the row, for the situations when the total count value is most frequently used than reading the a

Re: sstable2json not loading CLASSPATH properly?

It actually *is* in the default source, just not in the ubuntu package. I sent a message over to the package maintainer about it. Cheers, Jason On Mar 13, 3:22 am, Norman Maurer wrote: > What about creating a bugreport and attach the needed changes. I bet > cassandra devs love contributions

Re: json2sstable hanging on large sstable2json-generated JSON file

It eventually died with an OOM error. Guess the table was just too big :( Created an improvement request ticket: https://issues.apache.org/jira/browse/CASSANDRA-2322 Jason On Mar 12, 10:50 pm, Jason Harvey wrote: > Trying to import a 3GB JSON file which was exported from sstable2json. > I let it

Re: sstable2json not loading CLASSPATH properly?

What about creating a bugreport and attach the needed changes. I bet cassandra devs love contributions Bye Norman 2011/3/13, Jason Harvey : > nvm, I found the problem. Sstable2json and json2sstable require a > log4j-tools properties file. I created one and all was well. I guess > that should