NoSQL seems to me to be a scene as much driven by hype as logic. (For better or worse, practitioners using and programming NoSQL systems tend to have little understanding of the 30+ years of relevant RDBMS academic literature, and 20+ years of distributed RDBMS academic literature.)
Given that, NoSQL adoption often appears driven by success stories. But Cassandra seems to have the opposite: numerous failure stories. Facebook, Digg, Reddit and a number of others have all tried Cassandra in production, and have either had serious complaints or moved off to either SQL or other solutions like HBase.
Of course, these failure stories are anecdotes, and numerous unrelated factors (like bad interactions between Cassandra and Amazon's EC2) could be at fault. But I'm not sure it matters.
Has anyone on HN had a really good experience with Cassandra? (This may be the wrong thread to ask for obvious reasons.)