Scylla is a Cassandra-compatible NoSQL data store
Questions tagged [scylla]
342 questions
3
votes
1 answer
How to insert values in a table which has user defined types?
I am working with Scylla (Cassandra) db and trying to create tables which is dealing with User-Defined Types as shown below:
CREATE TYPE process (
id int,
discount float
);
CREATE TYPE service (
id int,
url text
);
CREATE TABLE…
dragons
- 549
- 1
- 8
- 24
3
votes
1 answer
IN Query in Cassandra Where clause
I have a Scylla cluster with 3 Nodes and 1 Table created with the below Query
CREATE TABLE id_features (
id int PRIMARY KEY,
id_feature_1 int,
id_feature_2 int,
)
I am issuing below query from the application
SELECT * FROM id_features…
sid
- 97
- 12
3
votes
1 answer
Creating local yum repo for scylladb and install it within private network?
I want to install scylladb on Centos and Redhat boxes. I found the installations instructions for the same here but this involves copying a .repo file and then using yum to install it i.e. it uses public internet).
I want to create a local yum repo…
RKM
- 67
- 1
- 5
3
votes
1 answer
how to extend the start up time for a scylla node if it is loading data
getting this error during startup time of scylla node as I am loading data
Nov 12 21:55:13 usw1-im-stage-scylladb1 scylla[53703]: [shard 0] database - Keyspace product_prod: Reading CF cleanup_transaction id=bb0a0640-058f-11ea-b8e4-00000000000c…
Mahee Gunturu
- 141
- 5
3
votes
1 answer
How to perform backup and restore of Janusgraph database which is backed by Apache Cassandra?
I'm having trouble in figuring out on how to take the backup of Janusgraph database which is backed by persistent storage Apache Cassandra.
I'm looking for correct methodology on how to perform backup and restore tasks. I'm very new to this concept…
Shr4N
- 435
- 3
- 18
3
votes
1 answer
Create a Global Secondary Index which include non-key attributes
I am trying to create a GSI on a table Scylla cluster. According to documentation I can create CREATE INDEX ON ks.users (email); which will include this field and the primary key in the Materialized view it creates. Is there a way I can project…
KingJames
- 546
- 2
- 9
- 20
3
votes
1 answer
How to optimize cross shard queries for scylla db using gocql
I'm using a scylla cluster with 9 nodes and replication factor to be 3.
One application opens one connections to it, reading and writing data.
However, I notice in the scylla CQL optimization monitoring dashboard, the percentage for cross shard is…
SilentCanon
- 626
- 4
- 11
3
votes
1 answer
Backup a keyspace in scylladb
I am trying to take a backup of my data in scylladb. Currently, my Scylla is in docker.
So I am running this command:
docker exec -it saif-scylla nodetool snapshot testkeyspace
Requested creating snapshot(s) for [testkeyspace] with snapshot name…
Saif Ali Khan
- 818
- 3
- 9
- 34
3
votes
2 answers
When does driver datastax driver paging yields fewer pages than requested?
I am trying to use datastax-driver paging using fetch-size. However datastax documentation says following
Note that setting a fetch size doesn’t mean that Cassandra will always return the exact number of rows, it is possible that it returns slightly…
Rakesh Patel
- 76
- 4
3
votes
2 answers
scylla-server is failing to start
After installing scylla server its failing to start with following error message,
Jun 04 07:07:56 localhost.localdomain scylla[29145]: Scylla version 2.3.5-0.20190417.0e0f9143c starting ...
Jun 04 07:07:56 localhost.localdomain scylla[29145]: …
Rima
- 31
- 2
- 4
3
votes
1 answer
Error while dropping column from a table with secondary index (Scylladb)
While dropping a column from a table that contains secondary index I get the following error. I am using ScyllaDB version 3.0.4.
[Invalid query] message="Cannot drop column name on base table warehouse.myuser with materialized views"
Below are the…
abasar
- 1,659
- 1
- 12
- 7
3
votes
3 answers
ScyllaDB version same after upgrade
I have followed the docs https://docs.scylladb.com/upgrade/upgrade-opensource/upgrade-guide-from-2.2-to-2.3/upgrade-guide-from-2.2-to-2.3-rpm/#upgrade-procedure and my version has remained the same. It has not upgraded to 2.3. Is there anything I…
shaolinLLama
- 55
- 6
3
votes
1 answer
Sstable upgrade required after scylla version upgrade?
I have checked scylla upgrade documentations found the steps.
https://docs.scylladb.com/upgrade/upgrade-opensource/upgrade-guide-from-2.1-to-2.2/upgrade-guide-from-2.1-to-2.2-rpm/.
As cassandra after binary upgrade we need to do perform sstable…
LetsNoSQL
- 1,478
- 1
- 11
- 23
3
votes
1 answer
Why the key prefix optimization doesn't work with secondary index on a clustering column?
Scylla DB implements, so-called "key prefix optimization" for secondary indexes, which eliminates filtering if a part of the primary key is specified. E.g. it's possible to execute SELECT * FROM A WHERE a = 'a' AND b = 'a' AND d = 'a'; on table…
Maksim Kolchin
- 517
- 1
- 7
- 17
3
votes
1 answer
