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
0
votes
1 answer

Replacing Cassandra Cluster EC2 Instances with AWS Keyspace using Java legacy driver

We are attempting to replace our existing Cassandra EC2 Cluster with AWS Keyspace and we are attempting to keep our old code base. The idea is to simply get out of the devops business and have our Cassandra managed by AWS (scaling, upgrades, etc.).…
0
votes
1 answer

How to connect to Amazon Keyspaces using boto3?

I'm trying to connect to Amazon Keyspaces leveraging the Assume role provider which refreshes the credentials the moment they expire. I've set up my aws config file as the documentation states [profile…
lealvcon
  • 178
  • 8
0
votes
2 answers

Spring Data Cassandra connectivity issue with AWS Keyspace

I've a simple crud based application in which Apache Cassandra is used as the default database. I've used Spring Data Cassandra for the Cassandra connectivity. Now, I'm trying to move into AWS Keyspace which which is well supported with the…
0
votes
1 answer

How to connect to AWS Keyspaces using .NET Core Lambda?

I was trying to follow the official AWS guide to connect to AWS Keyspaces using .Net Core. I tried to implement this code for a C# lambda function but I'm having trouble trying to add the Starfield X509 certificate to it in order to connect to my…
0
votes
1 answer

Amazon Keyspaces sync_table() doesn't see a table immediately

I am new in cassandra-driver==3.25.0. I've created a model from Model and tried to sync it. The problem: I am calling sync_table I see that table starts creating in Keyspaces and the definition is correct BUT sync_table raises an exception KeyError…
Ilya
  • 45
  • 1
  • 10
0
votes
1 answer

How to setup db connection between AWS EC2 hosted spring boot app and AWS key space?

Here I am trying to connect my AWS ec2 hosted spring boot application to AWS keyspace. Is there anything specific configuration that needs to be done? I am following this tutorial:…
ERK
  • 344
  • 6
  • 27
0
votes
1 answer

How transform this to CQL?

I have this line, how can i reproduce it into CQL? I'm using Amazon Keyspaces which based on Cassandra. DATEADD(day, @p_daysback, GETDATE());
Taifunov
  • 533
  • 1
  • 4
  • 9
0
votes
3 answers

How to check keyspace and table size in Amazon Keyspaces

We recently migrated from Cassandra to AWS Keyspaces and I am just wondering how to check for table and keyspace total size in AWS keyspaces. Any help or suggestions are much appreciated.
karnish
  • 79
  • 1
  • 10
0
votes
2 answers

How do I add permissions in Amazon Keyspaces?

When I try to query AWS Keyspaces (managed Cassandra) from an AWS Lambda, I get this error: { "errorType": "AggregateException", "errorMessage": "One or more errors occurred. (All hosts tried for query failed (tried 11.11.111.11:9142:…
sdgfsdh
  • 33,689
  • 26
  • 132
  • 245
0
votes
2 answers

Amazon Cassandra connection timeout on EC2 instance (Elastic Beanstalk)

I cannot connect to Amazon managed Cassandra (Keyspaces) from my EC2 instance. The EC2 instance is in a private subnet of a VPC with a VPC endpoint for Keyspaces. EC2 outbound rules: All TCP 0.0.0.0/0 VPC Endpoint inbound rules: Custom TCP TCP…
sdgfsdh
  • 33,689
  • 26
  • 132
  • 245
0
votes
1 answer

Amazon Keyspace NoHostAvailableException

I am running a Spring Boot application and using Spring boot cassandra to connect to keyspace. Following are the properties being…
0
votes
1 answer

Are the errors for DML statements (select, insert, etc.) recorded somewhere for AWS Keyspaces (Cassandra)

I'm getting a vague error back from AWS Keyspaces that I'm trying to troubleshoot, but it looks as though AWS only stores DDL statement logs for Keyspaces in Cloudtrail, and not DML. I can see the 'error count' in my dashboard in the AWS Console…
Gary Sharpe
  • 2,369
  • 8
  • 30
  • 51
0
votes
0 answers

When searching for values, do I need to use all the columns specified in the partition key for a quick result?

Let's say we have a chat room. Each chat room has several participants. In my case, it's one client and several operators (1 or more). Also, each chat room has its own specific theme. As we know in the Cassandra database, tables need to be designed…
Nurzhan Nogerbek
  • 4,806
  • 16
  • 87
  • 193
0
votes
1 answer

Authentication Exception when trying to connect to Amazon Keyspaces using .net core and cassandra csharp driver from linux

I created a keyspace(table) in amazon keyspace and was trying to get the records from it to my .net core application which was running in ubuntu.I have provided every thing required such as ".pem" file username,password and awsEndpoint as mentioned…
0
votes
1 answer

unable to connect spring boot java application to amazon keyspaces

This is the configuration class . @Configuration @PropertySource(value = { "classpath:cassandra.properties" }) @EnableCassandraRepositories(basePackages = { "com.example.demo.repository" }) public class CassnadraConfig extends…
Chintamani
  • 1,076
  • 7
  • 23
  • 47