Hi I am using cassandra for my project. my cassandra version is 0.6.4 and java version is 1.6.0_17 I had took the backup of cassandra using sstable2json and when i was trying to restore the same data using json2sstable , i am getting the error like at org.apache.cassandra.tools.SSTableImport.addToSuperCF(SSTableImport.java:118) ...
Hey. I am Developing a Web Crawler,Which is Good for storing data? Cassandra or Hadoop Hive or MySQL?and why?i am having 1TB of Data from past 6 Months in my MySQL DB,i need to index them and i need to get the out put in my search ASAP,and as i think,it will store more amount of DATA,like 10 Peta Byes as my crawler are working fast,i nee...
We are looking at using a NoSQL database system for a large project. Currently, we have read a bit about MongoDB and Cassandra, though we have absolutely no experience with either. We are very proficient with traditional relational databases like MySQL and Microsoft SQL, but the NoSQL (key/value store) is a new paradigm for us. So basic...
I have a Cassandra ColumnFamily (0.6.4) that will have new entries from users. I'd like to query Cassandra for those new entries so that I can process that data in another system. My sense was that I could use a TimeUUIDType as the key for my entry, and then query on a KeyRange that starts either with "" as the startKey, or whatever th...
I think these three are the most popular non-relational db:s out there at this moment. I want to give them a try, but I wonder which one of these are most suitable for Rails when it comes to Gem, documentation and tutorial support. Eg. if I install a very good gem that is for Rails but this just use AR and mongodb, then it would be a p...
If you have RDBMS you probably have to use Solr to index your relational tables to fully nested documents. Im new to non-sql databases like Mongodb, CouchDB and Cassandra, but it seems to me that the data you save is already in that document structure like the documents saved in Solr/Lucene. Does this mean that you don't have to use So...
The more I read/use non-sql databases, the more I love it. It's so for the OOP world and it's easy to use, like Rails for Frameworks. I know the disadvantages. The major concern seems to be the no-transaction and no-concurrency part. Am I correct? Are these the only features making it hard for developers to choose to use non-sql datab...
I know there are three different, popular types of non-sql databases. Key/Value: Redis, Tokyo Cabinet, Memcached ColumnFamily: Cassandra, HBase Document: MongoDB, CouchDB I have read long blogs about it without understanding so much. I know relational databases and get the hang around document-based databases like MongoDB/CouchDB. ...
I'd like to use Cassandra to store a counter. For example how many times a given page has been viewed. The counter will never decrement. The value of the counter does not need to be exact but it should be accurate over time. My first thought was to store the value as a column and just read the current count, increment it by one and then...
What is a simple way of configuring a cassandra cluster so that if I try to store a key in it, it will be stored in the local node to which I issue the set/write command? I am looking at the IPartitioner which allows me to specify how the key will be hashed but it seems a bit heavy weight for something like above. Thanks! ...
I just spun up a machine on EC2 running Cassandra following the instructions in the link below, but I have no idea what version it is. How do I figure this out? I know I'm missing something incredibly simple, just don't know where to look. http://wiki.apache.org/cassandra/CloudConfig ...
Over vacation I read Pat Helland's "Life Beyond Transactions" (yes, vacation was that good :). To sum it up briefly, it advocates limiting the scope of transactions to a single entity and then using groups of "activities" that have the ability to update the entity or cancel a task anytime a change takes place that would make that task in...
I work on large database (hundreds of GB) and Mysql now gives me more or less satisfaction. I hesitate to cassandra on launch. What I want to know everything before, so this kind of DBMS NoSQL is supposed to be faster than MySQL? Several points: The change in the number of column on a row In Mysql, they must all be defined in advance...
I am having a lot of trouble trying to upgrade my existing library from Cassandra 0.6 to 0.7 beta1. I had originally thought it was a order of operations issue, so I decided to break it down to the basics. Here is the basic setup that I will be suing TTransport framedTransport = new TFramedTransport(new TSocket("localhost", 9160)); ...
I need to get the data from cassandra with out case sensitive. Please help me. ...
Hi, I just wanted to know if there is a fundamental difference between hbase, cassandra, couchdb and monogodb ? In other words, are they all competing in the exact same market and trying to solve the exact same problems. Or they fit best in different scenarios? All this comes to the question, what should I chose when. Matter of taste? ...
Hello all, I am working with Cassandra 0.6.5 using the thrift interface. I am trying to use the batch_mutate method call, however, when I execute it, I receive no error message. This leads me to believe it worked. When I check using the CLI, there is nothing there. Is there something wrong with my code or format of the mutation_map ...
Hey. I created a new Pylons project, and would like to use Cassandra as my database server. I plan on using Pycassa to be able to use cassandra 0.7beta. Unfortunately, I don't know where to instantiate the connection to make it available in my application. The goal would be to : Create a pool when the application is launched Get a c...
I looked into Cassandra Wrapper, but the download from a blog that claimed to update the client was missing files. Anyone gotten PHPcassa or another client to work with .7 beta of Cassandra? ...
Well, NoSQL is a buzzword right now so I've been looking into it. I'm yet to get my head around ColumnFamilies and SuperColumns, etc... But I have been looking at how the data is mapped. After reading this article, and others, it seems the data is mapped in a JSON like format. Users = { 1: { username: "dave", passwo...