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
1answer
5 views

What's the advantage of the inet datatype in Cassandra vs a plain text string?

What is the inet datatype really for? The documentation refers to its usage having something to do with Python but I'm not much of a Python guy so that aspect is beyond me. Is there any advantage to ...
1
vote
0answers
4 views

Why restore a single node of a cluster?

We were reviewing the restore documentation for Cassandra here, and noted it made the following distinction between restoring a single node or an entire cluster: If restoring a single node, you ...
1
vote
0answers
19 views

What are the implications of using quite large partitions (rows) in Cassandra?

I am looking to store data in Cassandra, due to the fact that I have many writes that need to perform well, and all my reads can be done based on primary key. While doing the data modeling, however, I ...
0
votes
1answer
150 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 ...
1
vote
1answer
20 views

sstableloader returns `java.lang.NumberFormatException: For input string: “Filter.db”`

I've been using the Java API to create an SSTable by following the instructions on this site. The program compiles and works fine; no errors. However when I try to load the table using the following ...
1
vote
1answer
24 views

Error after upgrading datastax to version 5

After upgrading to DataStax Enterprise version 5, the node does not come up, and I get this error in the log: Insufficient permissions on directory /hints Where is this directory located?
2
votes
2answers
248 views

Migration from Cassandra 2.x to 3.x: schema_keyspaces table is gone. How do you query system keyspaces?

I just migrated from Cassandra 2.x to 3.x (specifically, 3.4). Now the system tables have completely changed, and these changes are not in the documentation. If you look at the current CQL docs for ...
0
votes
0answers
19 views

decommisioning and relaunching/rejoining a weird behaved node

Had weirdly almost double data on one node after a rebuild of it thougt token ownership was similar to other nodes ~7%. So I decommissioned it, remove all files (commitlog and sstables eta.) Launched ...
0
votes
1answer
20 views

Setup Cassandra Database

I have a very simple cassandra database with just one table containing the following records: device ID - long integer representing the device the 'value' came from - primary key tag ID ...
0
votes
1answer
16 views

customize permission in Cassandra

i want to grant user update permission in Table and deny delete permission for this user. Is there any way to accomplish this?
2
votes
0answers
17 views

Is there a configuration option that lets me limit the percent of a hard drive that Cassandra uses?

I'm doing some testing with a small hard disk and I'd like to basically stop Cassandra in its tracks if a write or compaction or any other service brings that usage of the disk above a certain ...
0
votes
0answers
9 views

Datastax solr query

I have 1 dse search node in my little cluster. I can look for data using solr quey only from this node. Is it possible to execute solr query from not dse search node (with cassandra only) too? Thanks
2
votes
1answer
17 views

DSE Cassandra decimal type

I generated solrschema with dsetool on a table name seriesdata (its key is composed by seriesmetadata_id, initialtime; two decimal field). These fields are defined as DecimalStrField but they are ...
0
votes
0answers
24 views

Cassandra 2.0 notetool status does not agree on every node

Got a cassandra 2.0.17 cluster w/14 nodes each with 256 vnodes, data seems not evenly distributed within nodes FSes after loading data. But while currently running a repair on first node (never done ...
0
votes
1answer
43 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. ...
1
vote
0answers
40 views

Cassandra query performs differently at different times

I am using apache-cassandra-2.0.12 in production, with network topology strategy and ReplicationFactor : 3 in a cluster with 2 DC’s each contains 4 nodes While analyzing the response time for the ...
0
votes
2answers
127 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 ...
1
vote
1answer
23 views

Cassandra change replication factor hive datastore

I am trying to change replication factor of HiveMetaStore but I receive this message: cassandra@cqlsh:system> alter KEYSPACE HiveMetaStore with replication = {'class': '...
2
votes
1answer
73 views

Why does Cassandra recommend against creating an index on high-cardinality columns?

The Cassandra documentation states, Do not use an index in these situations: On high-cardinality columns because you then query a huge volume of records for a small number of results. See ...
4
votes
1answer
65 views

Cassandra one-to-many table design

I am new to Cassandra from 20 years of RDBMS, and over the last few days have been reading and watching everything I can get my hands on that applies to my situation. I'm sure this is a basic ...
0
votes
0answers
26 views

Cassandra filtering multiple items

I am attempting to learn Cassandra by taking my RDBMS database and create a nosql version of it. Forgive any mistakes I am just making a quick example so I can ask my question. Here is my example(...
1
vote
1answer
25 views

How to predict new node allocation in a Cassandra cluster?

I have a 5-node Cassandra cluster. Each node has disk space of 5TB. The real usage for each node is around 2.5TB depending on allocations and compactions (some are around 2TB some around 2.8). I ...
0
votes
1answer
82 views

Slow select from one billion rows GreenPlum DB

I've created the following table on GreenPlum: CREATE TABLE data."CDR" ( mcc text, mnc text, lac text, cell text, from_number text, to_number text, cdr_time timestamp ...
0
votes
0answers
22 views

Cassandra Multi Datacenter Different Data Size

I have a cassandra cluster which consists of 2 datacenter. datacenter2 is only for live backup and added existing cluster for this purporse. After run rolling repair on each node, nodetool status ...
0
votes
0answers
7 views

Is making a recursive hard link of all files inside cassandra data file directory a safe way to back up the entire database?

I have a single node cassandra cluster running on my local machine. I want to back up my data file directory. My question is pretty simple. Say I was to search the entire data file directory and ...
0
votes
0answers
42 views

Cassandra cluster monitoring linux script

I have opscenter but I am also looking for having a Cassandra cluster monitoring script running locally on the cluster nodes. Simple "nodetool status" would be fine. Does anyone have a handy script ...
3
votes
2answers
2k 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. ...
0
votes
1answer
31 views

how to disable delete in replication Cassandra datastax

my previous scenario i used Sql server one instance in amazon for live and the second in local network for archiving by disable delete in replication can i do this in Cassandra or what best ...
0
votes
0answers
34 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 ...
3
votes
2answers
148 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 ...
2
votes
1answer
264 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
27 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. ...
2
votes
1answer
221 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
68 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 ...
1
vote
1answer
383 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 ...
0
votes
0answers
71 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 "...
2
votes
1answer
72 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, ...
4
votes
2answers
3k 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?
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 ...
8
votes
2answers
10k 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 ...
8
votes
2answers
591 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 ...
4
votes
1answer
2k 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
216 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 ...
1
vote
1answer
116 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 ? ...
1
vote
1answer
3k 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 & ...
1
vote
1answer
104 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 ...
0
votes
0answers
162 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, ...
1
vote
0answers
136 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
1answer
76 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
64 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 = ...