Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [cassandra]

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.

1
vote
1answer
72 views

Apache Cassandra INSERT-only permissions

Looking at the Cassandra documentation, it appears that the smallest write-only permission on a table you can grant is MODIFY, which includes UPDATE, DELETE and TRUNCATE. Is there a proper way to ...
1
vote
0answers
184 views

Error on cassandra-3.11.3-1.noarch centos7

I've a cluster consisting of 5 cassandra nodes. The cassandra version used is cassandra-3.11.3-1.noarch The keyspace strategy and is defined as follows: CREATE KEYSPACE my_keyspace WITH ...
1
vote
0answers
21 views

Kill client connection to Cassandra instance

Not able to go to find any documentation on how to kill a client connection to remote Cassandra I will instance .. as a DBA at the server end? Seems like an easy task but why no mention of this in ...
1
vote
2answers
68 views

password expire duration and maximum invalid login attempts

how to set password expire duration and maximum invalid login attempts for user under Cassandra DB ? for example user test tried to login with incorrect password 5 times , that should should get ...
1
vote
0answers
282 views

List Roles on cassandra getting NoHostAvailable on one DataCentre

I have a 2 DC cluster, 'main' and 'bi' with a replication factor of 3 and a NetworkTopologyStrategy. When I call LIST HOSTS; in cqlsh, my bi datacentre lists all the roles appropriately, but I get a ...
1
vote
0answers
284 views

Increase timeout for cassandra native transport threads?

From the Cassandra documentation here native_transport_max_threads The maximum number of thread handling requests. Similar to rpc_max_threads, but this property differs as follows: The ...
1
vote
0answers
117 views

Is my schema for a Discussion forum using Cassandra optimum or has a scope for improvement?

I am designing a Discussion Forum for my app which has following primary objects: Image Video Text Audio The owner can start a discussion in context of any of the above object. Based on user ...
1
vote
0answers
55 views

Is it possible to have a partition to distribute transaction load horizontally in SQL Server 2016?

In Cassandra, you can have a partition key to align partitions to particular server nodes. My understanding is that you can distribute transactional responsibility horizontally in SQL Server 2016 (...
1
vote
0answers
43 views

What type of primary key we need to use for specific length of bits in Cassandra?

I want to know in which situations which type of primary key I need to use. Situations: 1. If I need 64 bit key than is bigint is the best for it? If I will chose text type will performance will be ...
1
vote
0answers
270 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
1answer
264 views

Upgrading Cassandra [duplicate]

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
2answers
2k views

Commercial database systems versus open source database systems [closed]

Can anyone tell me what are the reasons for buying a commercial database system and not using an open-source free version? The reason for my question is that: Commercial systems cost upwards of 10....
0
votes
2answers
388 views

Correct way to perform backup of Cassandra/Scylladb

What's the correct(advisable) method to backup a cassandra or scylladb so that we can restore it on development environment with ease?
0
votes
1answer
2k 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
1answer
32 views

What things we should consider when configuring Cassandra Cluster?

I'm new to Cassandra, so wanted to understand what basic things we should consider when are we going to configure Cassandra cluster in on or multiple database centers? Thanks!
0
votes
1answer
1k views

ConnectException: 'Connection refused'

My node worked normally, and I could use nodetool status normally, but when I changed endpoint_snitch to Ec2Snitch I started getting the error: nodetool: Failed to connect to '127.0.0.1:7199' - ...
0
votes
1answer
219 views

How to set Cassandra volumes?

I have started a Cassandra server using Bitnami AMI, I have attached volumes to the EC2 instance, but how would I set Cassandra to use the attached volume?
0
votes
1answer
972 views

Cassandra nodetool repair parallelism: “parallel” versus “dc_parallel”

If I run nodetool repair --full I see settings like this: repairing keyspace some_keyspace with repair options (parallelism: parallel, primary range: false, incremental: false, job threads: 1, ...
0
votes
1answer
152 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 (https://stackoverflow.com/questions/463677/alter-table-without-locking-the-table) to maintain a single row ...
0
votes
1answer
28 views

Data replication in Cassandra

We have a 5 node cluster in Cassandra in which we have created a keyspace with RF=3. After creating a column-family(table) when we insert the data into the same, it is getting replicated in all the ...
0
votes
1answer
375 views

Python version issue on Cassandra 3.11.2

Searching around I found a lot of thread about this problem (coming from 2012) but I can't find an official solution: running cqlsh.bat File "C:\apache-cassandra-3.11.2\bin\\cqlsh.py", line 146 ...
0
votes
2answers
38 views

Cassandra Cluster storage

I want to try out Cassandra Cluster. My main question is about scalability. Every node in a Cassandra cluster has the same copy of data. So when I have in total 1 TB and have 5 nodes -> 5TB. This at ...
0
votes
2answers
160 views

Handling read conflict in cassandra?

Say we have three nodes(simple replica no sharding) i.e. N1,N2 and N3 with replication factor as 3. As read and write request can go to any node, Say Request write request(to update the same ...
0
votes
1answer
49 views

best way to retrieve data using multiple parameters in Cassandra?

I have created a table that contains the userid, the content that they posted on their newsfeed, the date of when they posted it, and a primary key(I am using nodejs) my first shot at retrieving the ...
0
votes
1answer
36 views

Cassandra - reinserting a node

I had to remove a cassandra dead node on a hurry (because an important script with a truncate query wouldn't work due to consistency level reasons -- any thoughts on that would be nice too). Anyway, ...
0
votes
1answer
743 views

Why doesn't nodetool work on my Cassandra Cluster?

I have never been able to get nodetool to operate correctly to give me information about my cluster. We have a simple 3-node cluster of Cassandra 3.11.1 nodes running under CentOS 7.3 -- using the ...
0
votes
1answer
714 views

Cassandra Consistency Level

I have 3 virtual Cassandra nodes cluster. Node1, Node2 & Node3. I have written a small python code to bulk load data into it. 1st time only 2 nodes out of three are available online, Node1 & ...
0
votes
1answer
149 views

MyRocks vs Cassandra data size

Both MyRocks (MySql) and Cassandra uses LSM architecture to store their data. So I have populated around 5 million rows in MySql with MyRocks as storage engine and also in Cassandra. In Cassandra it ...
0
votes
1answer
371 views

What is an efficient storage method to store Graph Data from GraphX (Spark)?

I generate graph data using Spark's GraphX library and I need an efficient way to store graph data. I have access to Apache Cassandra and ideally I want to store the graph data in there but the issue ...
0
votes
1answer
237 views

can I set a MAX Limit to a BIGINT cassandra's data type?

can I set a MAX Limit to a BIGINT cassandra data type? this is my first step in cassandra db. for example: bigint(10) just like in mysql?
0
votes
1answer
52 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?
0
votes
1answer
151 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
2answers
1k 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
1answer
246 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 ...
0
votes
0answers
33 views

What is the best compaction strategy for overwritable/mutable/upsert-able data?

Suppose I have a Cassandra table like this: CREATE TABLE keyspace.last_modified ( category text, subcategory text, id text, created_at bigint, PRIMARY KEY ((category, subcategory, ...
0
votes
1answer
8 views

Show cassandra help documentation in terminal instead of browser

I've just started playing around with Cassandra through the cqlsh cli. When using the help command for the topics the documentation opens in the browser. Is there a way to show the documentation in ...
0
votes
1answer
20 views

cassandra nodes have diff value

I have 3 node cluster, problem is that for some rows , updatetime column have different value on 3 node: like : 1st node : updated_on | 2018-08-22 17:01:30+0530 2nd node : updated_on ...
0
votes
0answers
69 views

OpsCenter missing in Datastax Cassandra for Windows

Following this guide within the Cassandra installer I should get OpsCenter too. But this screenshot https://www.datastax.com/wp-content/uploads/2012/01/dsc-win4.jpg doesn't match the current release (...
0
votes
1answer
22 views

SQL Join vs NoSQL Wide column

If we need to have 2 tables, one storing the author info(author_info), & another storing all the books info(book_info). author_info has authorId as it's primary key, whereas the book_info table ...
0
votes
1answer
37 views

Hints gc_grace and expirations

Have 3 node cluster. RF=3. Table with gc_grace_seconds = 120 secs. max_hints duration as default at 3 hours. inserted a row nodetool flush on all the 3 nodes bring down node 3 delete the inserted ...
0
votes
0answers
593 views

dropping a table does not delete the directories on the disk

I am just testing the drop table command in Cassandra 3.11. The sequence is as follows: Load data worth 10gb drop the table on the node, nodetool flush nodetool clearsnapshot nodetool cleanup ...
0
votes
1answer
12 views

How these conflicting scenarios will work in cassandra when one of the mode crashes?

Say we have two nodes(simple replica no sharding) i.e. N1,N2 with replication factor as 2. I am using default Read and write consistency levels i.e. R and W are 1 which means it will read/write from/...
0
votes
0answers
21 views

Handling write conflict in cassandra? [duplicate]

Say we have three nodes(simple replica no sharding) i.e. N1,N2 and N3 with replication factor as 3. As read and write request can go to any node, Say Request two write request(to update the same ...
0
votes
1answer
46 views

Replica model in Cassandra vs Mongo?

Say in Mongo we have one primary and two replica node(simple replica no sharding). Read and write request will be handled only primary node and replica will just backup the data in case of failover. ...
0
votes
1answer
149 views

Cassandra nodes are not equal

We have two nodes. Node1 was down for a long time. During this time Node2 raised 1 TB capacity when Node1 has 100 GB. We tried to repair Node1 with nodetool repair but nothing changed. After that we ...
0
votes
1answer
47 views

Can I use result of one query inside other query in Cassandra

I need to delete all rows with given clustering column value. I don't have partition key so I don't have complete primary key. To delete record from Cassandra table we need to provide specific ...
0
votes
1answer
568 views

Database latency vs throughput

I'm a bit confused by terms latency and throughput in case of databases. My understanding is that latency represents time needed to perform a single request (e.g. insert or select), while the ...
0
votes
2answers
4k views

how to import a huge csv file into Cassandra?

I am trying to import a csv file into Cassandra which is very long. These are food products: ingredients, nutrition, labels... It comes from Open Food Data. List information on food products: ...
0
votes
0answers
47 views

Error while starting Cassandra 2.0.2 service

I am new to cassandra NoSQL database. When I tried to start cassandra I am getting bellow error. Command used to start. ./cassandra -f xss = -ea -javaagent:./../lib/jamm-0.2.5.jar -XX:+...
0
votes
1answer
64 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 ...