Scylla is a Cassandra-compatible NoSQL data store
Questions tagged [scylla]
342 questions
4
votes
2 answers
How does Scylla handles agressive memflush & compaction on write work load?
How does Scylla guarantee/keeps write latency low for write workload case, as more write would produce more memflush and compaction? Is there a throttling to it? Would be really helpful if someone can asnwer.
Bishnu
- 383
- 4
- 14
4
votes
1 answer
How to get stream ID for a particular partition key in Scylla
I have a table in Scylla
CREATE TABLE event (
eventSource TEXT,
createdAt TIMEUUID,
eventData TEXT,
PRIMARY KEY (eventSource, createdAt)
) WITH cdc = {'enabled':true};
now I wish to track inserts/updates done to this table…
let4be
- 1,048
- 11
- 30
4
votes
1 answer
How to guarantee monotonically increasing timeuuid when selecting from scylla
I have a table with timeuuid as a clustering key.
CREATE TABLE event (
domain TEXT,
createdAt TIMEUUID,
kind TEXT,
PRIMARY KEY (domain, createdAt)
);
I wish to select the data in order of this clustering key with the…
let4be
- 1,048
- 11
- 30
4
votes
1 answer
Datastax cassandra cpp_driver hangs when connecting to node
I setup a ScyllDB on my Debian 9.6 machine. When I run cqlsh I can connect to it and create tables, do queries etc..
Now I tried to write a simple program in C++ using the Datstax driver and it can't connect. It always blocks when it tries to…
Devolus
- 21,661
- 13
- 66
- 113
4
votes
1 answer
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 value) in SSTable or it will create a new partition…
SilentCanon
- 626
- 4
- 11
4
votes
1 answer
Scylla logs in CentOS and RedHat
We have installed open source scylla on redhat linux. After installation checking the logs but not able to find system.log file. In cassandra there is file called system.log where all logs are stored. but in scylla I can not see any log file.…
LetsNoSQL
- 1,478
- 1
- 11
- 23
4
votes
3 answers
Cleanup space in almost full Cassandra Node
I have a Cassandra Cluster (2 DC) with 6 nodes each and RF 2. 4 of the nodes (in each DC) getting full so I need to cleanup space very soon.
I tried to run a full repair but ended up as a bad idea since the space start increased even more and the…
Jibrilat
- 347
- 1
- 3
- 14
4
votes
2 answers
How does Cassandra (or Scylla) sort clustering columns?
One of the benefits of Cassandra (or Scylla) is that:
When a table has multiple clustering columns, the data is stored in nested sort order.
https://docs.datastax.com/en/dse/6.0/cql/cql/cql_using/whereClustering.html
Because of this I think…
Drew LeSueur
- 19,185
- 29
- 89
- 106
4
votes
2 answers
How to create full / advance text search in scylladb and cassandra?
I have installed the latest version of scylladb and cassandra in my centos os. i have tried allow filtering in select query but i don't need it, I want advance search or full text search in it, i have google it but couldn't find any solution, when i…
Sahibzada
- 143
- 1
- 11
3
votes
1 answer
Is the OR operator supported in ScyllaDB?
How does OR condition works in WHERE clause for SELECT statements in scylladb.
I have created secondary index on email. Below query works fine and return result.
cqlsh> select * from test.d_emp where email='robs@ex.com';
id | dept | email |…
Gopi
- 689
- 1
- 8
- 17
3
votes
1 answer
Error accessing Scylladb cluster outside docker container
I'm running Scylladb locally in a docker container and I want to access the cluster outside the docker container. That's when I'm getting the following error: cassandra.cluster.NoHostAvailable: ('Unable to connect to any servers')
Datacenter:…
john meiners
- 93
- 5
3
votes
1 answer
Is the scylladb build hardcoded to work only with gnu gcc?
The python configure.py contains a line
gcc_linker_output = subprocess.check_output(['gcc', '-###', '/dev/null', '-o', 't'], stderr=subprocess.STDOUT).decode('utf-8')
The comments before this line indicate scylladb uses a custom dynamic linker and…
Kenneth
- 41
- 3
3
votes
1 answer
What is the Likelihood of Multiple Compactions Overlapping in ScyllaDB?
In the open source version, Scylla recommends keeping up to 50% of disk space free for “compactions”. At the same time, the documentation states that each table is compacted independently of each other. Logically, this suggests that in a…
Bradford Griggs
- 439
- 2
- 15
3
votes
1 answer
How does Scylla Evict Data from its Cache?
How does Scylla determine when to evict data from its cache? For example, suppose table T has the following structure:
K1 C1 V1 V2 V3
I populate the above table with 500 rows (e.g, the query SELECT * from T WHERE K1 = X & C1 = Y returns 500…
S.O.S
- 848
- 10
- 30
3
votes
2 answers
ScyllaDB: Schema vs. No Schema?
On one hand, ScyllaDB markets itself as a wide-column database which implies that a single row can contain any number of columns and the number of columns don’t have to be uniform across rows.
On the other hand, the Scylla docs state that it is…
S.O.S
- 848
- 10
- 30