Questions tagged [cassandra]

Cassandra is a highly scalable, eventually consistent, distributed, structured row/column store.

Filter by
Sorted by
Tagged with
0
votes
1answer
17 views

Heap Memory default allocation in Cassandra

As per cassandra-env.sh the default heap memory allocation for a 440G Total RAM should be 32765M (Maximum CAP before JVM Swithches to 64 bit reference). So, why is it showing 32210157568 bytes(30718M)...
0
votes
1answer
11 views

Cassandra installation 'module' object has no attribute 'decompress

After installing Cassandra 3.11 version on ubuntu 19.04 I am getting the following error once I fire command cqlsh [email protected]:/etc/cassandra# cqlsh Connection error: ('Unable to connect to any ...
0
votes
0answers
27 views

How to remove chars from alphanumeric values in cassandra column?

I have data model as shown below. My problem is in the marks column instead of int values alpha-numeric values got inserted so need to clean-up this column by removing characters from each alpha-...
0
votes
0answers
11 views

How to implement spring-boot-starter-data-cassandra for multiple keyspaces?

We're hoping to use spring-boot-starter-data-cassandra to implement a connection to our Cassandra data base via an API. However, we want to switch the keyspace value based on the request sent to the ...
0
votes
0answers
16 views

Error in TestCassandra - A needed class was not found. … Missing class: com/google/common/util/concurrent/FutureFallback

I upgraded my set up to Play 2.7, Silhouette 6 and also updated TestCassandra to 2.0.4. My set up uses cassandra 3.11.4. When I start my test, I get error A needed class was not found. This could be ...
0
votes
2answers
25 views

load data from cassandra to flink

How can i read from cassandra using flink in java or python.I didn't find a good documentation on this subject.And i want to connect this code to my website.How is that. I have this code but it runs ...
-1
votes
1answer
16 views

how to get data from two tables in Cassandra [on hold]

I want to get all product liked by user should also return product name and also get all user name who liked the product in Cassandra. I make two table user and product .so what should I do after that ...
0
votes
0answers
18 views

JanusGraphException: Could not execute operation due to backend exception

I'm going crazy because of this exception when starting up JanusGraph. It happened between restarts of the gremlin-server, without even touching the configuration files. This error always appears at ...
2
votes
1answer
26 views

CassandraEntityBase in C# DataStax Driver

I have a .net core application which persists data to a Cassandra instance through DataStax driver. I have a base class for my Cassandra entities. Now if I want to take my TimeUUID type id into this ...
0
votes
1answer
9 views

Parallel Full table scan with cassandra golang

We need to list all records present in one of our cassandra table, with no other technological alternative available other than cassandra kafka , may be Redis or Memcache. I have tried using token ...
0
votes
0answers
23 views

Cassandra 3.11.3 and RHEL 7 compatibility

Am trying to run Cassandra v3.11.3 on RHEL 7 system. But facing memory errors while trying to start Cassandra. Facing following error: OpenJDK 64-Bit Server VM warning: INFO: os::commit_memory(...
0
votes
0answers
28 views

How to run multi datacenter, each data center on single server and multiple nodes in Cassandra? [on hold]

I am trying to simulate a multi datacenter cassandra system with 3 servers. each server has multiple nodes running in it(using cassandra cluster management). I want to connect these servers so that ...
0
votes
1answer
16 views

Error while overwriting Cassandra table from PySpark

I am attempting to OVERWRITE data in cassandra with a PySpark dataframe. I get this error: keyword can't be an expression I am able to append the data by df.write.format("org.apache.spark.sql....
1
vote
1answer
22 views

Suddenly high write latency for one table in metrics

We are suddenly observing high write latency in metrics for one table (devices). This is a tiny table with <100 entries where we update a field regulary. This is on a 3 node cluster with RF=3. ...
0
votes
0answers
12 views

Keeping configuration data with history

We're developing an application that keeps timeseries data. We've been using cassandra database for this purpose. Approximately 5000 records are uploaded every half an hour. We have recently decided ...
1
vote
1answer
33 views

Read large data from cassandra to python dataframe (memory error)

I am trying to read feature vector of 2048 dimension (1 miilion records) from cassandra to pandas dataframe it crashes every time. I have 32 GB ram but still i am not able to read all data into ...
1
vote
2answers
25 views

single cluster 2 node datacenter, for replication testing taking 1 node down then i getting error while trying to run the select query in other node

Single cluster 2 node datacenter, for replication testing taking 1 node down then i getting error while trying to run the select query in other node. Also, the consistency level is ONE and ...
1
vote
1answer
20 views

I have single cluster 2 node datacenter, while doing replication testing i make 1 node down then i getting error by running nodetool status command

I have single cluster 2 node datacenter, while doing replication testing by making 1 node down and trying to connect cqlsh in other node getting the below error. Also, I have checked the consistency ...
0
votes
1answer
24 views

Not able to do escape query

iam new to cassandra, i want to do get query using cassandra python client? iam not able to escape special characters.can anyone help Below is the query which iam trying, but getting syntax error ...
0
votes
1answer
21 views

Cassandra metric TotalDiskSpaceUsed: does it include replication factor?

As per Cassandra documentation about the TotalDiskSpaceUsed metric: Total disk space used by SSTables belonging to this table, including obsolete ones waiting to be GC’d. What is this "disk space ...
1
vote
1answer
31 views

Cursor based pagination in Cassandra?

I am planning to build cursor-based pagination APIs for the data in Cassandra. Does Cassandra Java driver support cursor-based pagination? Or what would be a good approach to achieve this?
-1
votes
0answers
31 views

Invalid or unsupported protocol version error after insert several times in Cassandra with datastax java driver

Tomcat starts working normally and after the services add data to cassandra several times, I get an unsupported version error. The error is as follows; com.datastax.oss.driver.api.core.servererrors....
0
votes
0answers
24 views

how to retrieve row information from Cassandra in Go

I have the following code and am struggling to get rows to display: func handleViews(w http.ResponseWriter, r *http.Request) { var name string query := "select * from view" iterable := ...
0
votes
0answers
13 views

Cassandra: CorruptSSTableException when opening Descriptor instance

I'm trying to read data from SSTable files in a directory using Java. Here's what I have now: Descriptor descriptor = new Descriptor("md", new File("path-to-directory"), "test", "people", 1, ...
1
vote
1answer
30 views

What happens when I “select * from ColumnFamily” in a given Cassandra Cluster

Can someone explain and provide the document that explains the behavior of select * from <keyspace.table> Let's assume I have 5 node cluster, how does Cassandra DataStax Driver behave when ...
0
votes
0answers
31 views
+50

How to use Testcontainers Cassandra with Spring Data for Apache Cassandra?

I develop integration tests for my spring boot application, which works with Cassandra. I use CassandraTemplate for communication with Cassandra. I have the following config for the database src/test/...
1
vote
0answers
37 views

Cassandra: Java equivalent method to `sstabledump`?

I'm writing test for a java program which outputs cassandra sstable files (e.g. mc-1-big-Data.db). Now what I have is an correct output file (correct.db). To check if the program is correct or not, I ...
1
vote
1answer
31 views

How to overwrite fields when you COPY FROM data?

Is it possible to somehow overwrite existing counters-fields when COPY FROM data (from CSV), or completely delete rows from the database? When I COPY FROM data to existing rows, the counters are ...
0
votes
2answers
42 views

Handling C# Nested Classes in Cassandra

I have a C# class as like below public class User { public string UserId { get; set; } public string Name { get; set; } public List<Address> Address { get; set; } } public class ...
1
vote
0answers
29 views

cassandra node to node encryption throws unable to gossip with peers exception

We currently run a multi region cassandra cluster in AWS. It runs in four regions, 12 nodes per region. It runs without node to node encryption (or client encryption either). We are trying to ...
0
votes
0answers
16 views

How to batch insert with quill dynamic queries?

I'm trying to use Quill dynamic queries to perform batch insert In non-dynamic api I would've used: db.run(quote { liftQuery(myCollection).foreach(data => querySchema[MyDBClass]("table").insert(...
0
votes
0answers
117 views

How to fix ' environment error and package when installing cassandra using conda'

I'm installing Cassandra on my Mac through anaconda but i have a problem with the environment :failed with initial frozen solve. Retrying with flexible solve. furthermore it gives The following ...
3
votes
1answer
32 views

How does ScyllaDB/Cassandra handle partial update?

Assuming there is one row which has 10 columns. If I only update one column, before the merging/compaction, will the database create a new partition with only the updated column (containing the new ...
1
vote
1answer
22 views

cassandra error “Batch too large” using python

i'm trying to insert json file into a cassandra table by retrieving columns from the json using json module then inserting it into cassandra using prepared statement.The file is 2778ko precisely.I can'...
0
votes
0answers
14 views

How to create cassandra tables with quill?

I'm trying to find a way to create cassandra tables with quill. I'm using version 3.4.1 so I'm able to leverage dynamic queries to define the table to query at runtime but I would also like to create ...
0
votes
0answers
34 views

Cassandra is not deleting rows after TTL expires due to Boolean columns

Having a table where I am setting the TTL to 7 days, I expect that the Cassandra will delete the rows after 7 days. My table contains Boolean columns which set the column to True ONLY when creating ...
0
votes
1answer
27 views

“ORDER BY is only supported when the partition key is restricted by an EQ or an IN.” cassandra

I have created my table like this.. CREATE TABLE test1.mytest ( id text, year text, time bigint, crtby text, data text, postid text, upby text, PRIMARY KEY ((id, year),...
0
votes
1answer
62 views

cassandra.cluster with pyinstaller not working

I am trying to create executable using pyinstaller on my Mac for a simple python file TestAudit.py, which contains from cassandra.cluster import Cluster And getting below error when I run my ...
4
votes
1answer
44 views

Is one large AWS instance better than several smaller instances for the scylladb

I have one scylla db cluster with 9 nodes and RF=3 using amazon AWS i3en.xlarge instance. I'm curious if 3 i3en.3xlarge are much better than 9 i3en.xlarge.
0
votes
0answers
31 views

How to store multiple records into cassandra table using spring crudRepository interface?

I am trying to store a list of entities in to a cassandra table with single call to saveAll method of spring crudrepository interface. I am using save method of the crudRepository but iterating the ...
1
vote
1answer
37 views

Data is replicated/copied on my 2nd node even with a replication factor of 1 for the key-space

I have a Cassandra cluster of 3 nodes and I create a keyspace 'abcd' using SimpleStrategy and ReplicationFactor 1. Since I have chosen RF as 1, I assume that any writes to my node-1 should not be ...
0
votes
1answer
43 views

Collections$UnmodifiableRandomAccessList<E> Cassandra Frozen Map

I have a below UDT in my table productsinfo FROZEN<productsinfo> and this is the UDT schema for productsinfo "owned_product_details" map<text, FROZEN<list<FROZEN<productdetails>...
0
votes
1answer
37 views

“ServerError: java.lang.IllegalArgumentException: null” when querying a table in Cassandra?

I'm receiving an error "ServerError: java.lang.IllegalArgumentException: null" whenever I query anything in a particular table. Example Queries I've tried: select * from audit; select * from audit ...
0
votes
0answers
23 views

InvalidQueryException: Undefined column name typeid

I have the following database pojo for an employee class. The tables are already created @Table(value = "employee") { public class Employee implements Serializable{ @Id @PrimaryKeyColumn(...
1
vote
1answer
63 views

IP swapping in Cassandra cluster

We have healthy running 3 nodes cassandra cluster but we need to swap all 3 nodes IP address due to some issue. So basically, we want to swap old cassandra server IP address from to new cassandra ...
1
vote
2answers
25 views

How to have similar cassandra.yaml across cluster?

I want to configure a cassandra cluster and i want that the cassandra.yaml configuration file will be the same cross the nodes. the problem is that the listen_address has to be different on each node. ...
0
votes
0answers
27 views

Cassandra,order is wrong [duplicate]

I have a question about Cassandra. At present, "entities_by_time" is ok on the 18-bit uuid through column1 sorting, but there is something wrong with uuid ascending to the 19-bit sorting. Please help ...
0
votes
0answers
13 views

Cassandra SSL Storage port 7001 not binding with IPV6 address

I need to configure IPv6 based cassandra setup, for that did all the recommended changes, but SSL storage port 7001, not binding with IPv6 address :: or the configured Ipv6 address, is there any ...
0
votes
1answer
27 views

Presto map<varchar,set<varchar>> : How to query a field in presto which is of type map<varchar,set<varchar>>

I am trying to search a column having the data type map<varchar,set<varchar>>. I keep getting Query failed (#20190809_163618_00200_yyc4a) in your-presto: null Any help is appreciated. ...
1
vote
2answers
25 views

DSE Cluster node disk gets filled

I have an 6 node cluster , each node is of 1000 GB in size. But the size of one node reached to 1000 GB randomly.On analysis i found only one key space gets filled & only 1 table of this keyspace ...