Apache Cassandra is an open source distributed database management system. It is designed to handle very large amounts of data spread out across many commodity servers while providing a highly available service with no single point of failure. It is a NoSQL solution.

learn more… | top users | synonyms

0
votes
0answers
10 views

How to create multiple graphs with titanDB(+cassandra , +rexster) in the same machine?

I'm experimenting with TitanDB (with Cassandra as storage) + Rexter. I have used different storage.keyspace value for different graphs in Titanrexster-server.xml thn also i m not getting multiple ...
0
votes
0answers
17 views

Cassandra in a Public Cloud - Which Snitch?

I am planning on deploying Cassandra in a public cloud (like Amazon AWS). The cluster will span multiple zones and regions. The cluster will also require logical DC separation within a given region. ...
0
votes
0answers
13 views

Cassandra DB Schema for Article, Comment on Comment

What is the efficient way to store the comments on comments in Cassandra so that retrieval will be easy(just through the partition key) e.g. There is article and people can comment on that article. ...
0
votes
0answers
22 views

Appropriate Design For Notification System

I am using Cassandra to store a list of notifications that have been sent to a user. The few requirements I have are: Order the notifications for each user by time received (DESC) Be able to delete ...
0
votes
0answers
27 views

How to get Cassendra database dump with data

I need to get a dump(with data) from a remote Cassandra database. I was able to get database schema via following command. How can i get all data in the keyspace? I'm using Cassandra 1.1.9. echo -e ...
8
votes
2answers
296 views

NoSQL : What is unstructured data?

we are currently running at the edge of resources with our mssql server based solution. We have now many traditional options regarding the next move to tackle the load: buy faster CPUs and IO ...
1
vote
1answer
48 views

Filter rows, but only select most recent row for each Id

I have some code that is processing a lot of tasks. These tasks are either connected to a user or an account. Each Task go through many statuses -> Queued, Started, Error, Postponed, Queued, Started, ...
2
votes
1answer
117 views

How does the Cassandra distribute data?

I cannot find a detailed document on this anywhere, however, that being said, if anyone has an answer to my question, I would be extremely grateful. In regards to Cassandra's standard node ...
2
votes
2answers
64 views

Cassandra cluster monitoring

We using Nagios for our servers monitoring. Each web-environment have 1 cluster as backend - Cassanra 2.0. Each cluster have 3-5 nodes. Question is: I want write a plugin for Nagios, for Cassandra's ...
1
vote
1answer
81 views

How to Query Properties of an Entity in Apache Cassandra

I am new to Apache Cassandra, and I would like to know how to create a table in which I can filter rows by non-key columns. In relational databases, I would simply create a table with an ID as a ...
1
vote
1answer
47 views

cassandra in memory tables

I am planning to use Cassandra in memory tables for my particular work load. THe problem is I am worried if the node fails then what will happen to the data in memory that was not flushed to disk ? ...
0
votes
1answer
137 views

A good dataset to experiment NoSQL databases [closed]

I need to do some experiments in HBase and Cassandra and to do that I need an adequate dataset. The dataset I'm looking for has to be large enough (i.e. more than 2GB) and the data in it has to be ...
0
votes
0answers
103 views

Cassandra Database limitation

why Cassandra is limited to 65535 records only when stored in batch and loop is encounters 20000 only? I have inserted 20,000 customers but it shows an error like too many values for built statement, ...
0
votes
0answers
17 views

Running Cassandra on Encypted filesystem

Looking for pointers for running Cassandra on a Linux File system encrypted by open source tools. Will this satisfy "data-at-rest" encryption ? Is the encryption transparent to Cassandra DB ...
1
vote
0answers
94 views

What kind of database is Cassandra DB?

I was taking some courses to understand better the way Cassandra works (at academy.datastax.com) and by what I gathered it came to me that it is a Key Value Database because of the way it stores data ...
0
votes
0answers
70 views

Cassandra - save file

I'm new with Cassandra, and even more - I never have such task for habitual RDMS systems, like MariaDB or Oracle. So, how can I store file in to Cassandra's table? Preferably using Python-driver, but ...
0
votes
0answers
29 views

How to connect Cassandra database with Chicago Boss Application?

My cassandra database is on a VMware server. The problem is that I don't find any database adapter which can help me in connecting my cassandra database with my chicago boss(a web framework in Erlang) ...
0
votes
0answers
40 views

What is the graveyard compaction in cassandra?

Cassandra noob here. While going through the documentation etc, I'm repetitevely finding references to graveyard compaction (and occasionally tombstones), example: $ cassandra-cli [default@unknown] ...
0
votes
1answer
62 views

How Wide-columns databases achieve dynamic columns on the storage layout? [closed]

As known, in relational databases, when adding a new column, data must be reallocated (http://stackoverflow.com/questions/463677/alter-table-without-locking-the-table) to maintain a single row ...
2
votes
0answers
50 views

Update a Record in Cassandra

I'm having the following query while updating a particular record. I've a user Column Family CF as follow:- class User(Model): user_id = UUID(default=uuid.uuid4,primary_key= True) date = ...
1
vote
0answers
41 views

Cassandra- Data modelling for UserProfilie [closed]

I've a user model, having attributes as follow:- class User(Model): user_id = columns.Integer(primary_key=True) username = columns.Text() email = columns.Text() fname = columns.Text() ...
3
votes
1answer
700 views

Modeling Graph Data in Cassandra DB

I want to use Apache Cassandra to store a large amount of graph data according to a property graph model. The model contains the following entities: Vertices: Contains a map of key/value pairs ...
0
votes
1answer
480 views

What is the Cassandra setting for coordinator timeouts for schema change queries?

In my testing, I've found that the write_request_timeout_in_ms setting does not have any bearing on the timeouts for CREATE TABLE or ALTER TABLE statements in CQL. For instance, I have it set to ...
1
vote
1answer
226 views

Cassandra: memtable_offheap_space_in_mb and memtable_cleanup_threshold

I use C* v2.1.2 do write only workload (into one column family) and experiment with offheap-objects memtable space. I set parameters to: memtable_offheap_space_in_mb = 51200 # 50Gb ...
-1
votes
1answer
137 views

Database migration for Large Data Set from MySQL to NoSQL

I have an existing APP that has N types of products that is normalized with MySQL. Each types of products have over 500K skus, and one of them are in the in 2M currently. We are currently tracking on ...
1
vote
1answer
2k views

Cassandra row ordering best practice

I have a column family that store articles. I'll need to get those articles from the most recent to the oldest, getting them from Country, and of course the ability to limit the number of fetched ...
2
votes
1answer
438 views

Upgrading Cassandra from 1.1.0 to latest

I have a single node cassandra database running since 2 years now... never had any issues with it, but I would like to upgrade it to the latest cassandra (2.1.2 at the time I write those lines), of ...
2
votes
0answers
44 views

Cassandra Deployement Architecture

I'm new to Cassandra. I have the responsibility to design a basic deployment architecture for a use case. I'd like to know if my solution is correct, and get advice and recommendations from you. Here ...
3
votes
2answers
2k views

Do you have to run nodetool repair on every node?

Do you have to run nodetool repair on every node in a cluster, or do you only need to run it on one node, and from there Cassandra will take care of the rest?
1
vote
1answer
170 views

Date model for commenting system stored in a key-value NoSQL DB?

I'm trying to leverage Cassandra's strong support for time series data to build a commenting system. So far I'm thinking that each row would be a particular topic, and each comment would be a new ...
1
vote
1answer
3k views

Small startup: Cassandra + Hadoop or ElasticSearch

To give some context, I am from a small start up (4 team members) and we work in the education space. We've developed an e-learning platform that several schools are already using. We currently have ...
2
votes
1answer
160 views

Keeping rows ordered by counter value

I'm storing linked words in a Cassandra v2 cluster and I'm having a hard time doing efficient reads. I'm trying to fetch the top X rows with the highest counter value. Cassandra doesn't store the ...
0
votes
1answer
1k views

Allow filtering not working as expected

I'm having issues with getting ALLOW FILTERING to work. In our Cassandra 1.2 database, we have a table like this: CREATE TABLE some_table partition_key text, other_key text, non_key ...
2
votes
1answer
1k views

Cassandra: maintenance

I am inexperienced with Cassandra, but I have some experience with SQL-based relational databases. I have been unable to find best practices information about how to maintain Cassandra once deployed. ...
2
votes
1answer
972 views

How can I get nodetool without Cassandra

I have Cassandra pool across machines in LAN. I need nodetool on machine without Cassandra installed. How can I get it? Is the installing Cassandra and disabling db service is the best way?
1
vote
1answer
761 views

Cassendra schema design suggestion for chat archive

I have gone though this article and here is the schema I have got from it. This is helpful for my application for maintaining statuses of a user, but how can extend this to maintain one to one chat ...
0
votes
1answer
129 views

Upgrading Cassandra

my Cassandra version is 1.2.4 and i'm trying to upgrade it to 2.0.5 and i know that in the first part i have to upgrade it to 1.0.14 and after that try to upgrade it to the 2.0.5 , when I try to run ...
0
votes
1answer
142 views

Cassandra with Hadoop

Cassandra uses Cassandra File System (CFS) and Hadoop uses Hadoop Distributed File System (HDFS) I'm already using Pig over HDFS and i would like to install Cassandra. Having additional servers for ...
2
votes
2answers
2k views

How to create multiple graphs with TitanDB (+Cassandra) in the same machine?

I'm experimenting with TitanDB (with Cassandra as storage) + Rexter. I've been reading the documentation during hours and trying to create multiple graph DBs on the same machine, but I didn't find ...
-1
votes
1answer
72 views

Database software advice [closed]

I have this strange question. I'm building a service that stores information into one table. That table has 20 columns. My database will have many billion rows. Right now I'm using Cassandra, but it ...
2
votes
2answers
6k views

Is there any open source GUI tool to monitor cassandra? [closed]

I would like to monitor cassandra database as well as need to check the values in the database. Could any one suggest me best open source GUI tool ? Regards, Arun Raj.
1
vote
2answers
351 views

How does Apache Cassandra handle dynamic column set conflicts?

I know that each column in Apache Cassandra has a timestamp attached and that read conflicts for a single column is resolved deterministically by looking at timestamp or by comparing the value. Let's ...
5
votes
2answers
8k views

What is a good way to copy data from one Cassandra ColumnFamily to another on the same Keyspace (like SQL's INSERT INTO)?

Trying to find a way to easily transfer all the rows from a Cassandra ColumnFamily/Table to another. The COPY command, as I understand, is a good option. However, as it dumps all the data to .csv on ...
1
vote
1answer
2k views

Cassandra: Request did not complete within rpc_timeout

i was working with Cassandra 1.2.4 probably, after restoring some key-space when i tried to query in a key-space it gave me Request did not complete within rpc_timeout so i checked system.log & ...
3
votes
1answer
12k views

Cassandra - Query a column with collection type

I am pretty new to cassandra, so pardon me if this turns out to be a silly question. I have a table structure as below CREATE TABLE data_points ( id text PRIMARY KEY, created_at timestamp, ...
12
votes
1answer
288 views

Cassandra multidatacenter configuration with 1 external ip

I'm trying to setup a multi-datacenter Cassandra cluster. The problem is that my datacenters have only 1 external IP (wan IP), I can setup port forwarding on the data centers switchs to access each ...
0
votes
2answers
2k views

Cassandra in multiple data center - EC2MultiRegionSnitch

I was reading article from : http://www.datastax.com/docs/1.0/cluster_architecture/replication#networktopologystrategy and I have a question about - EC2MultiRegionSnitch. I did not understand it well. ...
48
votes
5answers
14k views

Which database could handle storage of billions/trillions of records?

We are looking at developing a tool to capture and analyze netflow data, of which we gather tremendous amounts of. Each day we capture about ~1.4 billion flow records which would look like this in ...
7
votes
1answer
3k views

What are the practical limitations on a column family in Cassandra?

In Cassandra, it's not recommended to have more than a few thousand column families, let's say 2,000 for the sake of argument. In cases where more than 2,000 types of data need to be persisted, one ...
2
votes
1answer
196 views

Which database to use? [closed]

Hey there. I am looking for a free to use for commercial website database that should have these design features, in the given order: Auto-Sharding (getting more free space by adding more server ...