Stack Overflow
Stack Overflow

Questions tagged [scylla]

Scylla is a Cassandra-compatible NoSQL data store

Scylla is a compatible data store.

342 questions
13
votes
1 answer

How do you call the data model of DynamoDB and Cassandra?

The DynamoDB Wikipedia article says that DynamoDB is a "key-value" database. However, calling it a "key-value" database completely misses an extremely fundamental feature of DynamoDB, that of the sort key: Keys have two parts (partition key and sort…
Nadav Har'El
  • 11,785
  • 1
  • 24
  • 45
11
votes
1 answer

ScyllaDB - [Invalid query] message="Collection filtering is not supported yet"

I have a table with a column of type list and I would like to check if there is an item inside the list, using CONTAINS keyword. According to scylla documentation: The CONTAINS operator may only be used on collection columns (lists, sets, and…
Giorgos Ntymenos
  • 361
  • 2
  • 13
8
votes
2 answers

Is there an API for scylla nodetool?

Is there an API for nodetool? Especially nodetool tablestats I saw there is https://github.com/scylladb/scylla/tree/master/api/api-doc. Is this the right place to look for APIs?
SilentCanon
  • 626
  • 4
  • 11
8
votes
4 answers

Is using IP address as primary key a good practice in scylla db?

I'm using scylla db and have a table using IP address as the primary key. The RF for the cluster is 3. I find some nodes have way more loads (take more disk space) than others even if the owns stats are close (31% ~ 35%) I am wondering is that…
SilentCanon
  • 626
  • 4
  • 11
8
votes
2 answers

Easy way to switch scylla cluster to large aws instances

I have a scylla cluster running on AWS i3en.xlarge instances which has 16 nodes. Is there an easy way for me to switch the cluster to i3en.2xlarge or i3en.4xlarge other than replacing existing node one by one (e.g. add a new node and remove a…
SilentCanon
  • 626
  • 4
  • 11
8
votes
1 answer

ScyllaDB - [Invalid query] message="marshaling error: Milliseconds length exceeds expected (6)"

I have a table with a column of type timestamp and when I insert a value, Scylla saves it with 3 zeros more. According to Scylla Documentation (https://docs.scylladb.com/getting-started/types/#timestamps): Timestamps can be input in CQL either…
elli
  • 497
  • 1
  • 3
  • 10
7
votes
2 answers

How to check ScyllaDB installed version?

I have run nodetool version and showing db version is 3.0.8 but if I am running scylla --version then it showing 2.1.1-0.20180325.cce455b1f. please help me which one is correct?
LetsNoSQL
  • 1,478
  • 1
  • 11
  • 23
7
votes
1 answer

Conceptual difference concerning column families in Cassandras data model compared to Bigtable?

I am currently trying to dig into Cassandra's data model and its relation to Bigtable, but ended up with a strong headache concerning the Column Family concept. Mainly my question was asked and already answered. However, I'm not satisfied with the…
OxideNt
  • 73
  • 3
7
votes
2 answers

Cassandra Vs ScyllaDB Memory Usage

I am doing performance comparisons of ScyllaDB and Cassandra, specifically looking at the impact of memory. The machines I am using each have 16GB and 8 cores. Based on the docs, Cassandra will default to 4GB Xmx and use the remaining 12GB as file…
Riley Zimmerman
  • 71
  • 3
6
votes
1 answer

How does JanusGraph Handles, Data consistency between Elasticsearch and ScyllaDb(Cassandra)

We are planning to use JanusGraph with ScyllaDb as our storage backend and elasticsearch as our index backend in production. ElasticSearch indexes the data stored in ScyllaDB, and we are not controlling how and when data is written in elasticSearch,…
Ankush
  • 83
  • 3
6
votes
2 answers

Scylladb : clustering key cartesian product size 600 is greater than maximum 100

I am using data stax java driver to query scylladb , i see this error while reading data from scylla RequestHandler: ip:9042 replied with server error (clustering key cartesian product size 600 is greater than maximum 100), defuncting connection.
ROHAN VADJE
  • 213
  • 2
  • 13
6
votes
2 answers

What is the effect of number of levels in levelled compaction?

I know how levelled compaction works in DBS like Cassandra, rocksdb etc. Some have max number of levels 4 and some have 7. How does this number affect compaction process? Why can't I have just 2 levels, 1st one which has flushed mem-table data…
Bishnu
  • 383
  • 4
  • 14
6
votes
2 answers

How to configure Cassandra TimeWindowCompactionStrategy

My time series data TTLs after 1-7 days (depends on the use case). The data is immutable and ordered by timestamp (cluster by timestamp) - data is timestamped "on-write" (so new data timestamps should always be progressive) The partition size should…
Avba
  • 14,822
  • 20
  • 92
  • 192
6
votes
2 answers

Cassandra/Scylla as graph database backen for JanusGraph and API exposed with GraphQl

I am looking for a Graph database using Scylla or Cassandra as the backend and then expose the web api as GraphQl. Can you help me verify that I have got the followin stack right: GraphQl or TinkerPop // Api schema, exposing api JanusGraph(privious…
Chris G.
  • 23,930
  • 48
  • 177
  • 302
6
votes
2 answers

Best practice modeling data for Cassandra databases

I'm new to Cassandra and am looking for a best practice on how to model data that has this general following structure: The data is "user" based (per customer) , each is supplying a big data file of around 500K-2M entries (periodically updated a few…
Avba
  • 14,822
  • 20
  • 92
  • 192
1
2 3
…
22 23