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.

50 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
110 views

Can Cassandra prevent TTL from updating on upsert of table

I have a Cassandra table that is like this... CREATE TABLE IF NOT EXISTS analytics.data( id double, data text, PRIMARY KEY(id, data) ) WITH default_time_to_live = 120 AND gc_grace_seconds ...
3
votes
0answers
154 views

Securing a Cassandra Cluster

We've managed to set up a Cassandra 2.2.6 cluster of two physical nodes (nodetool sees both of them, so I'm quite certain the cluster is indeed active). My steps to create the cluster were (this ...
3
votes
0answers
294 views

Is it good practice to have multiple keyspaces in Cassandra?

I've Cassandra configured on Amazon EC2 having 3 nodes(instances) in single cluster. Now what I want to do is give some space on Cassandra to my clients by creating separate keyspace for each in a ...
2
votes
0answers
37 views

Querying a High Cardinality Field

I am designing a data model for our orders for our upcoming Cassandra migration. An order has an orderId (arcane UUID field) and an orderNumber (user-friendly number). A getOrder query can be done by ...
2
votes
0answers
4k views

Cassandra - High Number of Dropped Mutations (Specific Table on a specific Node in the cluster)

History Leading to this issue: My Compression strategy in Production was LZ4 Compression. But I modified it to Deflate For compression change, we had to use nodetool Upgradesstables to forcefully ...
2
votes
0answers
535 views

Repair running too slow

Last week I asked a question that was answered below... I need to improve the question I asked earlier (in quotes below) and give a little more context. The answer below did help the repair ...
2
votes
0answers
135 views

Cassandra's nodetool snapshot renders node unresponsive

I have noticed that using nodetool snapshot on a Cassandra node causes heavy load (100% on two cores) for around 10-30 seconds. The snapshots are around 1GB in size. During that time connections to ...
2
votes
0answers
291 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 ...
2
votes
0answers
143 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 = ...
2
votes
0answers
87 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 ...
2
votes
0answers
321 views

Strugling with updating a cassandra row in FluentCassandra

I have this problem with using Fluent Cassandra in a test application. All I want to do is set the IsOnline field to true inside the SignIn method, but I keep getting the exception supercolumn ...
2
votes
1answer
41 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 ...
1
vote
1answer
27 views

Cassandra nodetool repair open files issue

I am using Cassandra 3.6. After nodetool repair Cassandra start takes too much time. The message is: ViewManager.java:226 - Not submitting build tasks for views in keyspace system_schema as storage ...
1
vote
0answers
20 views

Elassandra data modeling

In Cassandra, everyone always stresses how important data modeling is, and rightfully so. However, when using Elassandra, we have Elasticsearch baked in. How does should change how we think about ...
1
vote
0answers
47 views

Cassandra not returning the row of the specified primary key

First of all, my table is structured like this: CREATE TABLE timeseries_data.test_data ( date timestamp PRIMARY KEY, data1 float, data2 float ) WITH bloom_filter_fp_chance = 0.01 AND ...
1
vote
1answer
147 views

What happens if one DC goes down in Cassandra multi DC setup?

We have a Cassandra multi DC setup with 3 nodes in each DC, enabled with NetworkTopologyStrategy and RF 3. The java client interacts with Cassandra cluster using read and write consistency as ...
1
vote
0answers
16 views

compaction strategies and high performance storage

My apologies for this being a somewhat newbie question. However, my understanding of Cassandra is that is use three different compaction strategies: are these tunable, or is this area a black box, i....
1
vote
0answers
82 views

Cassandra slow read performance after migrating to new AWS instance class

Cluster of 3 cassandra nodes as a dev environment. Used to run in AWS on i3.2xlarge; migrated as a test to i3en.2xlarge to evaluate for later migrating production cluster to. When running cassandra-...
1
vote
0answers
194 views

Why getting Error accessing Cassandra with DataStax ODBC Driver?

We are using Cassandra 2.2.11, and trying to configure DataStax ODBC driver. We are getting the following error message: SQLSTATE: HY000[DataStax][CassandraODBC] (10) Error while executing a query ...
1
vote
2answers
2k views

Cassandra querying without full primary key

As far as I understand there are no secondary indices with multiple columns, only single columns. So how do I solve the index problem I'm having? This is my table: CREATE TABLE IF NOT EXISTS logstv....
1
vote
0answers
187 views

Cassandra pool warning displaying continuously

I am using the Cassandra driver for python in Spyder. I am trying to fetch some data from Cassandra table. Here is my code: from cassandra.cluster import Cluster cluster=Cluster(['some_ip']) session=...
1
vote
0answers
452 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
31 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
1answer
276 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 ...
1
vote
0answers
422 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
386 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
129 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
60 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
47 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
316 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 ...
0
votes
0answers
10 views
+50

is there a DDL generator out there where you can start with CSV/TSV to create DDL for Cassandra

Is there a DDL generator out there where you can start with CSV/TSV (or maybe even JSON) to create DDL for Cassandra?
0
votes
0answers
21 views

Choosing database type and schema for rental availability

I'm looking at what type of database and schema is best to use for product rental availability. The requirements are simply that it needs to cater for high writes and low reads. So I've been pushed ...
0
votes
0answers
35 views

Sigle sign on solution for Cassandra with Keycloak

Please suggest if there are possible solution of itegrating SSO for Cassandra with keycloak. I have searched for blogs for keyclock integration with cassandra. I couldn't find how to integrate these ...
0
votes
1answer
33 views

Cassandra security - private IPs with some VPN solution or public IPs and open ports?

there are many different solutions to secure a cassandra cluster. One of them is to enter public IPs and open the 7000/9042 port on each sever. Another one is to have everything in a private network ...
0
votes
0answers
28 views

How to use Apache Calcite (+ Cassandra) through NodeJS

When reading the documentation for Apache Calcite, it seemed astonishingly attractive as being part of a team currently porting an SQL application into Cassandra's popular CQL. After some more digging,...
0
votes
1answer
254 views

Cassandra goes down after some some days

I am running cassandra in 3 node cluster with replication factor 3. It was working fine for 2 days and all of a sudden it went down. I am beginner to cassandra database. I went through documentation ...
0
votes
0answers
50 views

utf8 errors retrieving strings from Cassandra

I have been tasked with fixing a problem seen occasionally in a Cassandra database when strings are retrieved, either programmatically or in CQLSH, and currently running with Cassandra version 2.1.15 ...
0
votes
1answer
42 views

Cassandra query response time degradation

I am experimenting with Cassandra on 4 sites with 2 nodes on each one. Have small network latency between them. I always query the data in DC where I inserted it. I see very strange behavior: when I ...
0
votes
0answers
18 views

Backup ScyllaDB/Cassandra remotely with compression

How can I backup ScyllaDB/Cassandra remotely? With PostgreSQL I can do something like this (backup, zip, transfer): mkdir -p tmp/backup OUTFILE=tmp/backup/db_backup_`date +%Y-%m-%d_%H%M%S`.sql.xz ...
0
votes
0answers
15 views

How to query on collection containing user defined data types in cassandra?

I am using Cassandra and I have created Type Participant as follows: CREATE TYPE soccer1.participant ( username text, participant_type text ); Table: CREATE TABLE soccer1.playground_table ( ...
0
votes
0answers
27 views

Cannot Connect to Cassandra on GCE

I just started learning how to use Cassandra, but at the moment I am trying to troubleshoot a small problem with GCE and Cassandra. I am not able to connect to it at all. I am using this Deployment ...
0
votes
0answers
26 views

Cassandra data modelling for IOT devices

We are building a micro service based IOT platform with a dashboard and views of various sensors etc. I have seen a few data modelling videos but I am not able to arrive at a good data model 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
94 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
30 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
155 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
1answer
1k 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
0answers
53 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
69 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
0answers
1k 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 ...