Differences in row iteration behavior

2012-09-14 Thread Todd Fast
Hi-- We are iterating rows in a column family two different ways and are seeing radically different row counts. We are using 1.0.8 and RandomPartitioner on a 3-node cluster. In the first case, we have a trivial Hadoop job that counts 29M rows using the standard MR pattern for counting

Rename a column family on 1.0.x

2011-11-01 Thread Todd Fast
Any advice for renaming a column family in version 1.0.x? Like most of the docs, the FAQ (http://wiki.apache.org/cassandra/FAQ#modify_cf_config) is out of date. Todd

Mixed random ordered partitioning?

2012-01-25 Thread Todd Fast
I want to do ranged row queries for a few of my column families, but best practice seems to be to use the random partitioner. Splitting my column families between two clusters (one random, one ordered) seems like a pretty expensive compromise. Instead, I'm thinking of using the

Delete doesn't remove row key?

2012-01-31 Thread Todd Fast
I added a row with a single column to my 1.0.8 single-node cluster: RowKey: ---- = (column=test, value=hi, timestamp=...) I immediately deleted the row using both the CLI and CQL: del Foo[lexicaluuid('----')];

Re: Delete doesn't remove row key?

2012-01-31 Thread Todd Fast
First, thanks! I'd read that before, but didn't associate doing a range scan with using the CLI, much less doing select count(*) in CQL. Now I know what to call the phenomenon. Second, a followup question: So the row keys will be deleted after 1) the GC grace period expires, and 2) I do a

Keyspace missing on restart

2012-02-10 Thread Todd Fast
My single-node cluster was working fine yesterday. I ctrl+c'd it last night, as I typically do, and restarted it this morning. Now, inexplicably, it doesn't know anything about my keyspace. The SS table files are in the same directory as always and seem to be the expected size. I can't seem

Re: Keyspace missing on restart

2012-02-10 Thread Todd Fast
I found the problem; it was my fault. I made an accidental change to my cassandra.yaml file sometime between restarts and ended up pointing the node data directory to a different disk. Check your paths! Todd On 2/10/2012 10:22 AM, Todd Fast wrote: My single-node cluster was working fine

Announcing Mutagen

2013-05-16 Thread Todd Fast
Mutagen Cassandra is a framework providing schema versioning and mutation for Apache Cassandra. It is similar to Flyway for SQL databases. https://github.com/toddfast/mutagen-cassandra Mutagen is a lightweight framework for applying versioned changes (known as mutations) to a resource, in this

Re: Announcing Mutagen

2013-05-17 Thread Todd Fast
at 11:06 PM, Blair Zajac bl...@orcaware.com wrote: On 5/16/13 10:22 PM, Todd Fast wrote: Mutagen Cassandra is a framework providing schema versioning and mutation for Apache Cassandra. It is similar to Flyway for SQL databases. https://github.com/toddfast/**mutagen-cassandrahttps://github.com

Re: schema management

2013-07-01 Thread Todd Fast
Franc-- I think you will find Mutagen Cassandra very interesting; it is similar to schema management tools like Flyway for SQL databases: Mutagen Cassandra is a framework (based on Mutagen) that provides schema versioning and mutation for Apache Cassandra. Mutagen is a lightweight framework

Re: abusing cassandra's multi DC abilities

2014-02-24 Thread Todd Fast
Hi Jonathan-- First, best wishes for success with your platform. Frankly, I think the architecture you described is only going to cause you major trouble. I'm left wondering why you don't either use something like XMPP (of which several implementations can handle this kind of federated scenario)

Dynamic schema modification an anti-pattern?

2014-10-06 Thread Todd Fast
There is a team at my work building a entity-attribute-value (EAV) store using Cassandra. There is a column family, called Entity, where the partition key is the UUID of the entity, and the columns are the attributes names with their values. Each entity will contain hundreds to thousands of

Re: Why does `now()` produce different times within the same query?

2016-11-30 Thread Todd Fast
FWIW I'd suggest opening a bug--this behavior is certainly quite unexpected and more than just a documentation issue. In general I can't imagine any desirable properties of the current implementation, and there are likely a bunch of latent bugs sitting out there, so it should be fixed. Todd On