Questions tagged [scylla]
Scylla is a Cassandra-compatible NoSQL data store
scylla
374
questions
0
votes
0
answers
12
views
How handling Concurrent Updates in ScyllaDB
I am using ScyllaDB and have a table called product with a column stock. When the stock changes, I perform a query to select the current stock, then calculate and update the new value in the database. ...
- 197
1
vote
2
answers
42
views
Cassandra 4.1 read timeout for a simple use case
I am running into read timeout problems which I would not expect.
3 nodes on commodity hardware and on my home network, replication factor 2
one simple keystore and table:
CREATE KEYSPACE IF NOT ...
- 399
0
votes
1
answer
30
views
How to use xandra (elixir package) in gleam?
I wanted to try out ScyllaDB with Gleam programming language (am beginner) but struggling with establishing connection from gleam. I wasn't able to find any cassandra drivers in gleam so using @...
- 1
1
vote
1
answer
78
views
Scylladb error LWT is not yet supported with tablets
i want to implement sequence in Scylladb so i created a table :
CREATE TABLE project.sequence (
name ascii PRIMARY KEY,
value bigint
);
Then i inserted a row:
INSERT INTO project.sequence (name,...
- 71
1
vote
0
answers
37
views
Getting 2x read requests on scylla
I have a spring boot kotlin app and I am using a scylla db cluster with 3 nodes. I am using datastax java driver with LOCAL_ONE consistency and Default load balancing policy.
I am doing load testing ...
- 21
1
vote
1
answer
98
views
Gocql Allow Filtering returns empty records with page size
Im using gocql to interact with my scylla database and implementing pagination using page states. However while using ALLOW FILTERING it returns empty records if the filtered data is not within the ...
- 11
1
vote
1
answer
40
views
How to expire a status (any field) after some time in golang using scyllaDB?
I want to expire a status field in my users table, just like how slack expires a status after the expiry set by the user.
I have integrated scylla cdc but scylla cdc does not give me the updated ...
0
votes
0
answers
75
views
Scylla not using all resources and poor tuning
When I stress test on my Scylla inside a docker I can't get more than 2000 successful write per second and write requests more than that will lead to time out even though I have dedicated a lot of ...
0
votes
0
answers
22
views
java.lang.IllegalStateException: Batch statement cannot contain more than 65535 statements in scyalla db using java driver
I am new in ScyllaDB. For my project I want to update one column(pin table) from another table (client). So at first I select col1, customerID from client table, then for each row: add row into batch ...
0
votes
0
answers
28
views
How to choose optimal tombstone_compaction_interval?
When using Size-Tiered Compaction Strategy (STCS) for Scylla, how to decide what value of tombstone_compaction_interval to use? https://opensource.docs.scylladb.com/stable/cql/compaction.html#common-...
- 3,274
0
votes
1
answer
169
views
ScyllaDB cqlsh JDBC Driver with DBeaver
I am trying to connect through ScyllaDB using a third party JDBC driver. I am largely referencing here: https://java-driver.docs.scylladb.com/stable/index.html#
Going to maven.com here: https://...
- 993
1
vote
0
answers
40
views
Unable to Update Data in ScyllaDB
I'm encountering an issue while attempting to update data in ScyllaDB using Go. Below is the code snippet I'm using for updating a session record:
func (q *Queries) EndSession(Sessionid string) error {...
- 11
0
votes
0
answers
42
views
Unable to Connect Scylladb From Scala, Scylladb Nodes are Running in Kubernetes
I'm trying to run Scylladb Nodes in k8s and access them from Scala (Phantom Library).
Kubernetes
Firstly I've followed commands from official scylladb documentation to create scylladb cluster.
$ ...
- 101
1
vote
0
answers
41
views
ScyllaDB hierarchical data storage
I have a data in below format
- Country (Root Object)
- State
- City
Each Country, State and City has an Id assigned to it.
Country has CountryID
State has StatueID
City has CityID
API which ...
1
vote
1
answer
22
views
Can I filter data across different columns in CQL with sorted order?
If I have the below data set:
id year location
------------------
1 2000 Tokyo
1 2001 NewYork
2 2000 London
2 2002 NewYork
and a CQL table that has,
PRIMARY KEY is (id,year);
I would ...
- 1,024