Thrift to cql : mixed static and dynamic columns with secondary index

Hi, I'm trying to migrate from Cassandra 1.1 and Hector to a more up-to-date stack like Cassandra 1.2+ and CQL3. I have read http://www.datastax.com/dev/blog/thrift-to-cql3

Deserializing mutations from commit log

Hi, I'm trying to deserialize the commit log in Cassandra for a research project. I have succeeded so far in deserializing the cell names and the cell values from the mutation entries in the commit log. However, am struggling to deserialize the primary key entries of the mutations since per

cassandra repair error

Hi, We're using Cassandra 2.0.10 ( 2 DC, 3 Nodes each RF=3 for each DC). During one of the weekly repairs, we received the following error: ERROR [ValidationExecutor:1280] 2015-07-12 22:18:10,992 Validator.java (line 242) Failed creating a merkle tree for [repair

Re: cassandra repair error

Hello, It seems that is a problem with Cassandra trying to delete a directory that is not empty. First time seeing this error. Are your harddrives with enough space and working correctly? Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: cjrolo

RE: cassandra repair error

The hard drives have plenty of space left and working properly as far as I know. We’ve been running Cassandra for almost a year now. It’s the first time we’re seeing this problem. I see a JIRA for v2.1 but that is with NFS.. We’re not using NFS. From: Carlos Rolo [mailto:r...@pythian.com]

Re: Thrift to cql : mixed static and dynamic columns with secondary index

This schema is something that we're providing a better CQL conversion for in 3.0. The one column you defined will become a static column, meaning there is only one copy of it per partition. The schema will look something like this: CREATE TABLE ref_file ( key text, folder text static,

Compaction Error

Hi All, I am trying to do compaction on the same node. But getting the below error any suggestion on this. 9160 Port is already opened nodetool -h testserv1 -p 9160 compact Error connecting to remote JMX agent! java.io.IOException: Failed to retrieve RMIServer stub:

Re: Compaction Error

Hi Kiran, Nodetool uses 7199 port to connect (JMX). Plus, you might want to precise what keyspace and table you want to compact. http://docs.datastax.com/en/cassandra/2.0/cassandra/tools/toolsNodetool_r.html http://docs.datastax.com/en/cassandra/2.0/cassandra/tools/toolsCompact.html C*heers,

Re: Using TTL in cassandra-stress

I don't know the stress tool that much, but I guess that if you are asking it might be no trivial way to do it. I imagine stress tool creates a table and fill it. You might want to do that once and then alter the table to set a TTL at table level. Once again, you might want to make sure the tool

questions about snapshots origin and removal

Hi all Quick questions. I was auditing disk usage of my cluster (cassandra 1.2.19). I found there was a node with 27G worth of snapshots in OpsCenter data directory. I don't remember doing any snapshots... I do run nodetool repair -pr every night, so they might be created by the repair process.