Questions tagged [scylla]

Scylla is a Cassandra-compatible NoSQL data store

Scylla is a compatible data store.

342 questions
0
votes
2 answers

Tombstone scanning in system.log

I have a cassandra cluster with less delete use case. I found in my system.log "Read 10 live and 5645464 tombstones cells in keyspace.table" What does it mean? please help to understand. Thanks.
LetsNoSQL
  • 1,478
  • 1
  • 11
  • 23
0
votes
2 answers

Cassandra/Scylla on docker without internet in linux server

I have installed docker on redhat/centos server. docker services are running fine but how I can install or build cassandra/scylla image on docker. my server is not connected with internet so while building cassandra/scylla image or run then getting…
LetsNoSQL
  • 1,478
  • 1
  • 11
  • 23
0
votes
1 answer

Scylla, datastax-java-driver integration problem

I have three nodes Syclla cluster. I have keyspace which has 3 replication factor. I use datastax-java-driver 3.6.0 version and Scylla 3.0.0 version. When I tried to read my data with consistency level = LOCAL_QUORUM, I get error message below…
Yılmaz
  • 185
  • 2
  • 14
0
votes
1 answer

Docker - IP address of container on Windows

The task is follows: Write node.js server that will work with a ScyllaDB, that will be placed on Docker container. I doing this earlier, but on Ubuntu, and its work fine, now I should do it on Windows 10. I installed Docker Toolbox for Windows and…
Max
  • 3
  • 2
0
votes
2 answers

User can view specfic keyspace not others if not admin rights?

While exploring cassandra, Is it possible in cassandra that if I created an user "test" and I have multiple keypsaces so if I am logging cqlsh with "test" then I can see only selected keyspaces not others.admin can view or switch all keypsaces.…
LetsNoSQL
  • 1,478
  • 1
  • 11
  • 23
0
votes
1 answer

Any UI log monitoring tool for cassandra system.log?

I am just looking any UI based tool to monitor cassandra system.log so that we could analyze and extract errors efficiently. if any please let me know the steps to configure.
LetsNoSQL
  • 1,478
  • 1
  • 11
  • 23
0
votes
3 answers

Astyanax cannot read some column families

I am trying to list the column families in Cassandra using the Astyanax driver. It lists the keyspaces OK, but many column families are missing from the output. I have a simple program for this: import com.netflix.astyanax.AstyanaxContext; import…
albertlockett
  • 204
  • 3
  • 13
0
votes
2 answers

Json insertion into scylla table

I am trying to insert json data into my scylla table but it is vomiting an error the commnd given is Insert into students json '{"lastname" :"Roy", "firstname" :"Kumar", "id" :2} `; And the error is Syntax exception : line 1:33 missing ' (' at'…
Suresh Kumar
  • 71
  • 1
  • 6
0
votes
1 answer

Access cassandra nodetool API progmatically

I need to provide similar utility functions such as is available through nodetool tablestats I've gone over their source code but didn't find a convenient solution to accessing it through code. Is there a library available for…
Avba
  • 14,822
  • 20
  • 92
  • 192
0
votes
1 answer

How can I improve performance of adding data to ScyllaDB?

I try to use prepared statements as it was described in the official Cassandra and Scylla documentation however performance is still around 30 seconds for 100,000 of messages. Any ideas how can I improve this? query = "INSERT INTO message (id,…
thedbogh
  • 614
  • 2
  • 10
  • 26
0
votes
1 answer

cqlsh unable to find the version of Python it needs to execute

When I type in: cqlsh in my terminal window, I get an error that says: -bash: /usr/local/bin/cqlsh: /usr/local/opt/python/bin/python2.7: bad interpreter: No such file or directory However, if I type Python --version the terminal verifies that …
0
votes
1 answer

Cassandra materialized view partition key update performance

I am trying to update a column in base table which is a partition key in the materialized view and trying to understand its performance implications in a production environment. Base Table: CREATE TABLE if not exists data.test ( 
foreignid …
Ankita
  • 2,798
  • 4
  • 18
  • 25
0
votes
1 answer

Where is the Compose Scylladb SSL certificate?

I'm trying to connect to my scylladb 1.7.4 instance using the connection string provided for me in the compose overview section of the management UI: $ cqlsh --ssl portal-xxxx.ibm-343.composedb.com 19228 -u scylla -p XXXX…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
0 answers

Cassandra selecting by reverse order of clustering order

I wan't to select rows by the order of ASC and DESC but cassandra data orders are fixed . I use ScyllaDB. My imaginary scenario of problem : I have a table : CREATE TABLE tbl(A text , B text , C text , primary key(A,B,C)) After inserting datas my…
KoLiBer
  • 194
  • 4
  • 15
0
votes
3 answers

cassandra select by clustering key

I have a problem with cassandra ( ScyllaDB ( indexes not supported ! ) ) in my scenario i have a table with three columns CREATE TABLE test (a text , b text , c text , PRIMARY KEY ( a , b ,c ) ); Now i want to select data's by the second cluster key…
KoLiBer
  • 194
  • 4
  • 15
1 2 3
22
23