cassandra

Cassandra full text search like

Let's say I have a column family named Questions like below: Questions = { Who are you: { username: "user1" }, What is the answer: { username: "user1" }... } How do I search for all the questions that contain certain words? Get all questions that contain 'what' word. How do I do it using python or at le...

What is the best way to map Java objects to the Cassandra data store?

I'm getting started with Cassandra, and have been using the Hector Java library, which seems to be the most popular at the moment. I'm trying to figure out how best to expose the data store to my Java code, and am trying to do something similar to the object-relational models I'm familiar with working with when using a relational data s...

How Cassandra handle part of cluster desynchronization?

What is going one when parts of the cluster don't see each other? For example: when 3/7 of cluster can't communicate with 4/7 cluster for coupe of hours. Each part of cluster use "hinted handof" for other one part? The data is rebalanced and replicated in each part of cluster? If I balance clients to each part of cluster for writes, aft...

Can't connect to cassandra : NodeContext killing all pooled connections for session

When I try to connect to cassandra within my java application I receive the exception at the end of this message. I am using pelops library to access database. Database is working on linux and my development environment is on windos 7. Intresting line is WARNING: 10.0.0.7 NodeContext killing all pooled connections for session 44 10.0....

Cassandra getting data (query on different attributes)

dear how i can get data from Cassandra using value posts = { '1': { //this post id 'user_id': '4', 'body': 'This is awesome!', }, } i cen get the post using post id can i get posts related to certain user i mean get post related to user_id=4 like an example (query using user_id attribute) regrads ...

Installing cassandra in ubuntu?

I have already installed cassandra in ubuntu using with wiki Problem is I have no control over which version to install and upgrade to in feature. I am want to be able to install specific version not just latest, because i have a machine running 0.6.2 now i want a another node and i want to install 0.6.2. How can i install debian pack...

Sequential Row IDs in Column Oriented DBs (HBase, Cassandra)?

I've seen two contradictory pieces of advice when it comes to designing row IDs in HBase, (specifically, but I think it applies to Cassandra as well.) Group keys that you'll be aggregating together often to take advantage of data locality. (White, Hadoop: The Definitive Guide and I recall seeing it on the HBase site, but can't find it....

what is the best api/library for java to use cassandra?

I'm looking for an api with the following requirements 1) It's simple to use and is concise. It is not bloated. 2) Works with Spring way of doing things, or is at least easy to make it work with Spring 3) Has a maven repository, preferably it's already in the main repositories 4) Is production-tested, meaning a fair number of people ...

Generate UUID for Cassandra in Python

Heh, I'm using cf.insert(uuid.uuid1().bytes_le, {'column1': 'val1'}) (pycassa) to create a TimeUUID for Cassandra, but getting the error InvalidRequestException: InvalidRequestException(why='UUIDs must be exactly 16 bytes') It doesn't work with uuid.uuid1() uuid.uuid1().bytes str(uuid.uuid1()) either. What's the best way...

Connecting and playing with Cassandra in Java

Hi guys I have read some tutorials on what Cassandra is and what it can do but my problem is how to interface with Cassandra in java? (A tutorial will be nice :-) ) If possible, can someone please show me whether I should use Thrift or Hector (which one is better and why)? Thanks in advance. PS Can I integrate Hibernate with Cassandr...

Cassandra over SQL as cache?

It's obvious that I'm not an expert on Cassandra. So the question may sound silly. Given an existing SQL-based project does it give any benefit or is it even possible to apply a no-SQL database(e.g. Cassandra) as an additional layer between business logic and SQL database to speed up our queries or inserts. It's relatively new technol...

Planning the development of a scalable web application

We have created a product that potentially will generate tons of requests for a data file that resides on our server. Currently we have a shared hosting server that runs a PHP script to query the DB and generate the data file for each user request. This is not efficient and has not been a problem so far but we want to move to a more scal...

Asp.net MVC + NoSQL Database(Cassandra)

Is there any good/simple asp.net mvc application that uses NoSQL database(cassandra)... Any suggestion... ...

Pruning Columns in Cassandra

Hi, I'm thinking about using Cassandra for a large data project. The data will be sourced from a traditional data warehouse. Cassandra will host the data formated in a way my application can correctly read it. I don't quite understand how I will prune the data from Cassandra. For example, I want to count the number of visits a partic...

Cassandra Installation Issue

Followed the steps to install the apache-cassandra latest build. Upon first startup (./cassandra -f), I get this: Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/cassandra/thrift/CassandraDaemon Caused by: java.lang.ClassNotFoundException: org.apache.cassandra.thrift.CassandraDaemon at java.net.URLClassLoader$...

Can I use cassandra with heroku?

Is it possible to use cassandra with heroku? ...

Handling storage of billions of pieces of information?

What is the best solution if I need to have a database with a billion+ objects and I need to have immediate (or nearly immediate) access to any of the items in the database at any time. This database would be queried at about 1000 requests per second. The rows in the database are pretty much unrelated and thus doesn't need to be relatio...

Cassandra - Impact of configuring ColumnFamilies

I'm in the process of researching into various NoSQL technologies and currently looking into Cassandra (so I'm at a beginner level with regard to this!). My understanding is you have to define ColumnFamilies in a config file - if you want to change a column family or add a new one, you have to restart Cassandra. What I'd like to know is...

Cassandra/BigTable data model - what's the best approach for building indexes?

I'm in the process of spiking a conversion from MySQL to Cassandra for PenWag.com. In Cassandra, I'm storing Users keyed off of a GUID, but users sign in with their email, not the GUID (obviously). GUID as a key for Users makes sense to me more than email for two reasons. From a practical perspective it seems that it's too cumbersome ...

How to start developing rails/django application using NoSql Database like cassandra?

Hello i want to use NoSql database in my rails/django application for learning point of view. What the various things i should kept in mind. Any tutorials? things to be kept in mind? Any Tips like do and don't? EDIT I am fully flexible. I want to learn. I know php,rails,django.I want to create some application using Nosql database a...