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

8
votes
2answers
87 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
0answers
23 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, ...
1
vote
1answer
24 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 ...
0
votes
0answers
17 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
53 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
20 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
65 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
43 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
9 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
38 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
32 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
19 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
33 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
45 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
31 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
30 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
259 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
260 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 ...
0
votes
1answer
94 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
92 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
508 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
244 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 ...
0
votes
0answers
6 views

Middle of Node replace

I had to replace a dead node, now I have two other nodes that are down. Can I shutdown the entire cluster in the middle of replace node process? If I resume do I have remove the JVM_OPTS=$JVM_OPTS ...
0
votes
0answers
55 views

Data modeling question on Cassandra DB

I'm trying to save events of a month for a user to my Cassandra DB instance. Each month the data will expire and will be removed. The data I try to model will contain user id, date of event and event ...
2
votes
0answers
39 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 ...
0
votes
0answers
75 views

Cassandra CL quorum giving inconsistent values

How is this even possible? cqlsh:keyspace> consistency Current consistency level is QUORUM. select * from email_idx where email='xxx@yyy.com'; email------------------- | user_id ...
1
vote
1answer
1k 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?
0
votes
0answers
28 views

cassandra:request didn't complete with rpc_timeout

cassandra:request didn't complete with rpc_timeout.I Have set up a cassandra server of only one node and import 60 lacs record.but when we run select query it show error of rpc_timeout over 10000 ...
0
votes
0answers
78 views

How to apply updates in a “Fan out on write” architecture?

If I copy certain writes to different tables for faster read performance on certain queries(fan out on write), how should I design updates? Since the data is spread over different tables, I'm trying ...
1
vote
1answer
133 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
2k 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 ...
1
vote
1answer
92 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
0answers
386 views

Cassandra cluster on Windows Machine

I am new to Cassandra, and have been trying to create a cluster using DevOps. When I add a node , I get the following error: Error provisioning cluster: Unable to SSH to some of the hosts ...
0
votes
1answer
665 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
672 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
611 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
507 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
98 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
112 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 ...
1
vote
1answer
1k 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 ...
1
vote
2answers
4k 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
263 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 ...
3
votes
2answers
5k 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
8k 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
251 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. ...
46
votes
5answers
12k 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 ...
6
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 ...