cassandra

Ruby on Rails + Cassandra on Netbeans?

This equation works good? Ruby on Rails + Cassandra on Netbeans6.9? I have try installing the gem activerecord-cassandra-adapter, but the installation never works good. Is there anybody using this? ...

What NoSQL solution is best to store Apache error_log and access_log? Cassandra or MongoDB?

We have developed PaaS solution for PHP. As part of that we offer developers to see Apache error_log and access_log files through our API. Currently we write the logs into files on disk seperated per deployment (vhost). Since this doesn't scale too well with a higher number of nodes and deployments, even though files are on distributed...

Book recommendation on distributed computing concepts used in Cassandra

What book would you recommend on distributed computing concepts/database internals such as the ones used for Cassandra, the concepts are listed here: Cassandra glossary? Thanks! ...

What are the best uses of document stores?

I have been hearing a lot about document oriented data stores like CouchDB. I understand the uses of BigTable like stores such as Cassandra. After reading this question, I was wondering what the conditions would be to merit using a document store? ...

How can I start start Apache Cassandra programmatically

Hi I want to embed Apache Cassandra in my Java program, how can I start it programmatically? ...

Data modeling in Cassandra

Hi, I'm building a data base where some users can put tag in others data. Something like Last.fm. How can I implement a DB in cassandra for this application. The Tag must be associate with the user and the data. Is there any data modeling pattern for cassandra? The Stack overflow tags is a good example of what I want to do! :) tha...

Bundling jars when submitting map/reduce jobs via Pig?

I'm trying to combine Hadoop, Pig and Cassandra to be able to work on data stored in Cassandra by means of simple Pig queries. Problem is I can't get Pig to create Map/Reduce jobs that actually work with the CassandraStorage. What I did is I copied the storage-conf.xml file from one of my cluster machines on top of the one in contrib/pi...

Cassandra versus Couchdb

I need to implement a massive databse with a relatively simple structure. That is few tables, no complex dependencies, etc. How would I begin to choose between say Cassandra and CouchDB? ...

Accessing timestamp of a Cassandra column

Hi All, I am new to Cassandra. I have a column Family where the columns are sorted by "LexicalUUIDType". How can I access timestamp of each column in such a ColumnFamily? I need to the timestamp because I have to read the oldest entry. I can not use "TimeUUIDType" for sorting columns. Thanks, ...

Can I expect a significant performance boost by moving a large key value store from MySQL to a NoSQL DB?

I'm developing a database that holds large scientific datasets. Typical usage scenario is that on the order of 5GB of new data will be written to the database every day; 5GB will also be deleted each day. The total database size will be around 50GB. The server I'm running on will not be able to store the entire dataset in memory. I've s...

apache cassandra query/full text search

Hi everyone, I've been playing around with apache's cassandra project. Done a fair bit of readin and i have some fairly complex examples that i've done, including inserting single and batch sets of data, retrieving a single and multiple data sets based on keys. Some of the articles i've looked at include http://www.rackspacecloud.com/...

TimeUUID with Cassandra and Lazyboy

Hello, I try to insert column with UUID1 keys to be able to sort them by date. I always get the error "cassandra.ttypes.InvalidRequestException: InvalidRequestException(why='UUIDs must be exactly 16 bytes')", and I don't know why. Here is the code generating this error : from lazyboy import * from lazyboy.key import Key import uuid c...

Complex Queries in Cassandra

Hi, How can I make complex queries in Cassandra? As example, I have a set of objects with id, name and others properties, and I want all Ids with the name starting with some string. Is that possible? Thanks, ...

Why does Cassandra act strange with byte keys (with Lazyboy) ?

Hello, I wrote a test program for testing Cassandra, and I had problems reading data. Seems like Cassandra sometimes takes one key for another. Here is my test program : from lazyboy import * from lazyboy.key import Key import uuid import random class TestItemKey(Key): def __init__(self, key=None): Key.__init__(self, "TestMX...

Is there any way to use Symfony PHP framework with Bigtable / Cassandra DB ?

Is there any bridge/native method to use the Bigtable / Cassandra DB arhitecture? ...

What should I choose: MongoDB/Cassandra/Redis/CouchDB?

Hi, We're developing a really big project and I was wondering if anyone can give me some advice about what DB backend should we pick. Our system is compound by 1100 electronic devices that send a signal to a central server and then the server stores the signal info (the signal is about 35 bytes long). How ever these devices will be se...

cassandra: Storing value?

Hi everybody, I wanted to make a tryout this weekend with Cassandra + PHP in my testing environment. So after a few hours of headache trying to install it, I finally succeeded and got it running. However, I've tried out the different PHP wrappers for cassandra, and I have totally failed to connect with anyone. SimpleCassie which I want...

Cassandra: Update multiple rows?

Hi everybody, In mysql, I can do the following query, UPDATE mytable SET price = '100' WHERE manufacturer='22' Can this be done with cassandra? Thanks! ...

Massive Database w/ Fulltext Search - Sphinx, Lucene, Cassandra, MongoDB, CouchDB....

Hello, Our company is working on a project that requires a database with 30-50 million rows of product data. These rows contain text that needs to be searched concurrently thousands of times per second. Moreover, each search needs to take less than one second to execute. So, all in all, we have a 50M row database that needs to be searc...

Question about DB of social networking websites

Like facebook, everyone has messages on the wall. Are all messages stored in only one table? And it will only display messages belong to the user's ID when loading the page? And if it is then there will be so many rows in that table. Is there any limit of the rows in one table? Or every user has one table only store their own messages? ...