What's the deal with Deno? We talk with a major contributor to find out. Listen now.

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.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 views

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?
1
vote
1answer
28 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 ...
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
39 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 ...
1
vote
1answer
27 views

Read from partition in local cassandra node only

I'm aware that I can read from any cassandra node and it acts as coordinator to read from the node containing a specific partition, but can I read data only from the partition which is on the node I'm ...
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
270 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 ...
1
vote
1answer
342 views

does a php 7.3 cassandra driver exist?

I have php 7.3 on Debian 10. I'm trying to get the Apache Cassandra driver for php 7.3. The one provided by datastax (https://github.com/datastax/php-driver) only works up to 7.1, and the pecl one (...
0
votes
0answers
53 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
46 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 ...
1
vote
1answer
156 views

How to insert nested UDT types

I have all these case classes :- case class Role(id:UUID, roleName:String, description:Option[String], isVisible:Boolean, isDefault:...
1
vote
0answers
48 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
150 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....
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 ...
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 ...
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
17 views

Cassandra multi data centre cluster configuration [closed]

We are decided to use "cassandra" as a database and now want to go with cluster with two datacenters DC1 & DC2. This DC2 is for backup purpose and it is replica of DC1. Initially we are expecting ...
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 ...
0
votes
1answer
32 views

Stopping N number of nodes of a Cassandra cluster running on a single machine using bash script

I have set up a Multi-Node cassandra (3.11) cluster (with N nodes) in a single Ubuntu machine. I have written a bash script which Creates N copies of conf folder Configures the cassandra yaml file ...
1
vote
1answer
2k views

Copy/move data from one cassandra server to another

I'm in the midst of replacing a kubernetes stack (to more specific: moving it from a locally hosted cluster to an AKS cluster in Azure), and as a result have to re-create all of my services, including ...
2
votes
2answers
158 views

Allocate space in Cassandra

We run a Cassandra cluster with 2 DC, 3 nodes each (2 RF). The state of the cluster is quite bad (never repaired) and the disks were getting full so we added additional nodes which after the bootstrap ...
1
vote
1answer
164 views

User Grant in cassandra DB

I would like a user abc to access only a single keyspace and no other keyspaces in the Database. How can I achieve so?
1
vote
0answers
197 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 ...
0
votes
1answer
11 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 ...
1
vote
2answers
320 views

Does Cassandra CQL provide a command to generate an execution plan?

In Oracle and other DBs you can generate an execution plan for SQL. Is this possible for Cassandra? I want to determine if it is possible to measure the relative complexity of several CQL statements ...
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=...
2
votes
1answer
49 views

Is there a way to change the compaction throughput via startup options in Cassandra?

We are currently running a Cassandra cluster in K8S containers as Stateful sets. We're considering exposing the config file but we would like to know if perhaps we can provide this value as a startup ...
2
votes
1answer
136 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 ...
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 ...
1
vote
0answers
454 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
1answer
516 views

How to deal with unbounded growth in cassandra shards

Let's say we have a website like youtube where we have a comment session per e video. Users want to be able to comment and to see the comments made by other users by comment creation time. This is ...
0
votes
1answer
38 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 ...
1
vote
0answers
32 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
2k 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 ...
3
votes
1answer
671 views

Cassandra multi-DC:write on LOCAL and read from any DC

We use a multi-data center (DC) cassandra cluster. During write on to the cluster, I want only LOCAL DC to perform writes on its nodes as we are already routing the write requests to the desired DC ...
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
2answers
64 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
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
157 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
1answer
17 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
2answers
397 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
75 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. ...