Stack Overflow
Stack Overflow

Questions tagged [amazon-keyspaces]

Amazon Keyspaces (for Apache Cassandra) is a managed Apache Cassandra–compatible database service that can migrate, run, and scale Cassandra workloads in the AWS Cloud. Being serverless, it automatically scales tables up and down in response to application traffic. Note: Apache Cassandra is an open-source, wide-column datastore that is designed to handle large amounts of data. For more information, see Apache Cassandra.

This tag is for posts about Amazon Keyspaces, which is AWS's managed Apache Cassandra service.

110 questions
3
votes
3 answers

Cannot set consistency level when querying Amazon Keyspaces service from DataGrip

I'm trying to perform inserts on Amazon's Managed Cassandra service from IntelliJ's DataGrip IDE, however I recieve the following error: Consistency level LOCAL_ONE is not supported for this operation. Supported consistency levels are:…
Jack
  • 886
  • 7
  • 27
2
votes
1 answer

Is there an alternative to logged batches on Amazon Keyspaces?

Our team decided to move with Amazon Keyspaces from self hosted Cassandra. After configured with Amazon Keyspaces I found that logged batches are not supported. In our solution there are multiple cases where it requires to use logged batches. Ex: We…
IsharaD
  • 322
  • 2
  • 4
  • 17
2
votes
2 answers

How do I configure consistency level with Spring Boot and AWS Keyspaces?

I hope you can help me, I am doing a crud with spring boot and keyspaces (cassandra aws), spring has the default level of Consistency level in ONE and I have not been able to write the data since I get the following error: "message": "Query; CQL…
Michael Torres Ospina
  • 53
  • 2
  • 11
2
votes
0 answers

Clear prepared statement cache in AWS Keyspaces on table definition change

Is there an easy way to clear prepared statement cache in AWS Keyspaces? Traditional tricks used on manual cassandra nodes cannot be used in the AWS Cloud. In Cassandra, if the table definition changes, this cache seems to be cleared. But I found…
zenbeni
  • 7,019
  • 3
  • 29
  • 60
2
votes
1 answer

Apache James with AWS Keyspaces for Cassandra

Trying to connect Apache James with AWS Keyspaces. James is able to connect but, failing with the above error after few seconds. According to the stack trace the exception is thrown from the above method. Any help is appreciated. Thank you,
Jishnu S
  • 71
  • 7
2
votes
1 answer

How to access Amazon Keyspaces via shell?

I tried writing cqlsh in the AWS shell, but it returned no output. I referred this tutorial output:- bash: cqlsh: command not found
Samar Pratap Singh
  • 471
  • 1
  • 10
  • 29
2
votes
2 answers

Cassandra Node.js driver - possible to toggle ALLOW FILTERING?

Our team has recently switched from self-hosted Cassandra to AWS Keyspaces. Although the "brochure" mentions Cassandra compatibility, we are actually losing some of Cassandra most critical functionality (with the important ones - UDT, Materialized…
dev7
  • 6,259
  • 6
  • 32
  • 65
2
votes
2 answers

Why is connecting to AWS keyspaces so slow with python's cassandra-driver?

I have one API, is an flask application with python deployed on AWS EC2. Some endpoints need to connect on AWS Keyspace for make a query. But the method cluster.connect() is too slow, takes 5 seconds for connect and then run the query. What I did to…
Vinicius Bass
  • 55
  • 7
2
votes
1 answer

How to replace logged batch in AWS Amazon Keyspace

I am moving my product from self-hosted cassandra node to Amazon Keyspace. One problem is that Amazon Keyspace is not supporting logged batches, cause it might use too many resources in some cases. In my code I have multiple cases where I need to…
M. Sokólski
  • 21
  • 1
2
votes
1 answer

Cannot connect to Amazon Keyspaces with cqlsh

I am having trouble connecting to Amazon Keyspaces, both with my application code and cqlsh: cqlsh cassandra.eu-west-2.amazonaws.com 9142 -u "xxxxxxxxxxxxxxx" -p "xxxxxxxxxxxxxxxxxxxxxx" --ssl Connection error: ('Unable to connect to any servers',…
sdgfsdh
  • 33,689
  • 26
  • 132
  • 245
2
votes
2 answers

How to fix problem "Unable to complete the operation against any hosts" in Cassandra?

I have a pretty simple AWS Lambda function in which I connect to an Amazon Keyspaces for Cassandra database. This code in Python works, but from time to time I get the error. How do I fix this strange behavior? I have an assumption that you need to…
Nurzhan Nogerbek
  • 4,806
  • 16
  • 87
  • 193
2
votes
1 answer

How do I sort data by the last update date in Cassandra?

I need advice to correctly design the table in Cassandra. I need to get a sorted list of all the books. Sorting is performed by the date of the last update. Each time a particular book is purchased, the number_of_buyers column is updated. Also, I…
Nurzhan Nogerbek
  • 4,806
  • 16
  • 87
  • 193
2
votes
1 answer

Connecting to AWS Managed Cassandra Service (MCS)

I have recently started using AWS's Cassandra Managed Service offering, and am trying to programmatically connect to the sample keytable AWS shows in their documentation. I've downloaded the Cassandra c# driver and gotten the generated service…
Mark McWhirter
  • 1,168
  • 3
  • 11
  • 28
2
votes
2 answers

Amazon Keyspace TRUNCATE instruction doesn't work

On Amazon Keyspaces on AWS I can't truncate my table.. Have you an idea why ? The instruction seems exist on CQL but doesn't work even on CQL editor on MCS. ...:~/.cassandra$ cqlsh ... ... -u "...." -p "..." --ssl Connected to Amazon Managed…
Damien Frances
  • 43
  • 6
1
vote
0 answers

Cannot get "system.peers" from AWS Keyspaces when using Shared VPC and Endpoint from diffrent account

We have 2 AWS accounts(111111111111, 222222222222). First account have VPS and Endpoint for cassandra service. This VPC share to the second account. How can get correct list of system.peers from aws keyspaces service from the second account? AWS…
Юра Гореликов
  • 11
  • 1
1
2
3 4 5 6 7 8