Scylla is a Cassandra-compatible NoSQL data store
Questions tagged [scylla]
342 questions
3
votes
1 answer
Cassandra - Same partition key in different tables - when it is right?
I modeled my Cassandra in a way that i have couple of tables with the same partition key - Uuid.
Each table has it's partition key and others column representing data for specific query i would like to ask.
For example - 1 table have Uuid and column…
Udi
- 598
- 8
- 19
3
votes
2 answers
Scylla db json support for insert with DEFAULT UNSET directive not working
I am trying the following insert statement with DEFAULT UNSET directive, but I get syntax error in the statement. I am using scylla 2.3.1. I tried to the syntax in Apache Cassandra and DSE. It works there.
CREATE TABLE user (id int primary key, name…
abasar
- 1,659
- 1
- 12
- 7
3
votes
1 answer
Setting up ScyllaDB + Janusgraph + Tinkerpop
About to start using ScyllaDB with JanusGraph, and Tinperpop3.
For now, I'll work with <200 gb data, so I want to do everything on my own (xeon based) computer.
My question is mostly: are some versions incompatible with each other?
For ScyllaDB I'd…
nick88
- 118
- 1
- 8
3
votes
4 answers
ScyllaDB 2.1 - Inconsistency with Materialized View
While deciding on the technology stack for my own product, I decided to go with scyllaDB for database due to it's impressive performance.
For local development, I setup Cassandra on my Macbook.
Considering ScyllaDB now supports (experimental) MV…
DroidBoyJr
- 89
- 1
- 6
3
votes
1 answer
Can I safely restore a Scylla backup from 1.6 in scylla 2.0 or 2.1
I'm reading the documentation on Scylla's upgrade procedures (
reading the dochttp://docs.scylladb.com/upgrade/upgrade-guide-from-2.0-to-2.1-ubuntu/ for example), and I'm seeing the standard "Stair-Step" path is required from 1.6->2.0->2.1, etc.
As…
s_kenkel
- 31
- 1
3
votes
1 answer
Monitor Scylla db using Prometheus and Grafana
I have installed scylla db in Server A.
Installed Prometheus and Grafana in Server B.
Monitoring the scylla db server resource(CPU , RAM , Disk perfromance ..,) using node exporter ( installed node exporter in Server A).
Need to monitor scylla db…
soundararajan.c
- 2,538
- 6
- 29
- 51
3
votes
2 answers
Connect remote scylla db server shows error
I have installed scylla-db in google cloud servers.
Steps i have followed:
sudo yum install epel-release
sudo curl -o /etc/yum.repos.d/scylla.repo -L…
soundararajan.c
- 2,538
- 6
- 29
- 51
3
votes
2 answers
Commitlog sync period
According to cassandra commit log sync period..data first goes to os buffer...then from os buffer, based on commit log sync period ,the buffer data gets synced to commit log file in disk..and the default sync period is 10 seconds..what if server…
Rupesh Mukherjee
- 75
- 1
- 7
3
votes
2 answers
Cassandra - unable to parse list of Tuple with Java driver
I am trying to access Tuple data structure I have stored in Cassandra with Mapper. But, I am unable to. I haven't found any example online.
This is the table and data I have created.
cqlsh:test> CREATE TABLE test.test_nested (id varchar PRIMARY KEY,…
spiralarchitect
- 880
- 7
- 19
3
votes
2 answers
Does Google Compute Engine offer SR-IOV (Single Root I/O Virtualization)?
Amazon / AWS EC2 offers SR-IOV (Single Root I/O Virtualization) instances, which it dubs "enhanced networking" -- does Google offer this on Compute Engine?
Specifically, are any GCE instance types able to bypass the hypervisor and have direct access…
espeed
- 4,754
- 2
- 39
- 51
2
votes
2 answers
Can skewness happen for r/w operations on scylla/cassandra cluster if phone number is used as primary key for the table?
I am running a spark job which populates a table in scylla. The primary key in the table is of long type and it essentially contains phone numbers. If we talk about potential values of this field, it will definitely not be uniform since most of the…
phantastic4
- 47
- 4
2
votes
2 answers
Cannot query with IN() on indexed column
I have simple table. Here is how it looks:
create table trip_stops
(
cid uuid,
stop_id uuid,
rate float,
date date,
primary key ((cid), stop_id)
);
CREATE INDEX ON trip_stops ((cid), date); // local secondary…
lkqWRHL23O
- 23
- 2
2
votes
2 answers
How do I get all rows where column has a value (exclude empty columns)?
I have DB where not all columns in DB have values, but I need to get only those rows which have values.
Example: My DB has 3 columns: "id", "first_name" and "last_name".
| id | first_name | last_name |
| -------- | ---------- | --------- |
|…
Yanick
- 49
- 5
2
votes
1 answer
How to use 'or' with 'where' clause for scylladb using phantom dsl?
I'm using phantom dsl library to perform scylladb operations. Now I was trying to combine 'where' clause with 'or' clause but its not working.
db.object
.select
.where(_.businessEmail eqs "abc@gmail.com")
.or(_.homeEmail eqs…
Zaryab Ali
- 161
- 7
2
votes
2 answers
Why "LIKE" , "Contain", "REGIX" Operators are not working in phentom-dsl library ( scylladb )?
I'm using scala language and scylladb database using phantom-dsl library.
I want to get the data of students from scylladb on the bases of city by using method ,
override def getStudnetByCity(city: String): Future[List[Student]] =…
Asif
- 198
- 10