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
1
vote
2 answers

How to export AWS Keyspaces tables from one AWS account to another in a different AWS region?

As cross-account, cross region replication is not yet available for AWS Keyspaces, what can we do to kinda support this usecase? I am thinking about either using an active-active topology between 2 regions / 2 accounts fed by a single stream, but it…
1
vote
1 answer

springboot 3 reactive cassandra keyspace DataStax config try to connect localhost

I'm trying to connect to amazon-keyspace AWS Casandra via my spring-boot-3 multi-module software but it tries to connect localhost / endPoint=/127.0.0.1:9042 instead. here is some of my build gradle plugins { java …
1
vote
1 answer

Why does my query to AWS Keyspaces using the Cassandra Python driver return an empty list?

I am trying to use a prepared statement to query keyspaces via python's cassandra driver. This is the query and it's preparation... from cassandra.cluster import Cluster cluster = Cluster( **conn_details ) session =…
Sam Comber
  • 1,237
  • 1
  • 15
  • 35
1
vote
2 answers

Is it possible to do a regex search in Amazon keyspaces?

I am trying to implement seach functionality based on the title field of entries present in amazon keyspaces. I was trying to do a regex match on the title field but I am not to figure out how it could be done. Does amazon keyspace supports regex…
1
vote
1 answer

how to check number of partitions count in amazon keyspaces?

how to check number of partitions count in amazon keyspaces ? is there a way to create dashboard to check no. of partitions creation whether no. of partition key is equal to no. of partitions ?
1
vote
3 answers

How do I reset the TTL for existing data in AWS Keyspaces table?

There are a way how to set TTL for existing raws in table without re-inserting all data? All documentation talks about examples when inserting record using custom/default…
Mindaugas K.
  • 433
  • 5
  • 12
1
vote
2 answers

AWS Keyspace DSBulk unload failed, "Token metadata not present"

Getting error when trying to unload or count data from AWS Keyspace using dsbulk. Error: Operation COUNT_20221021-192729-813222 failed: Token metadata not present. Command line: $ dsbulk count/unload -k my_best_storage -t book_awards -f…
1
vote
3 answers

Getting error when inserting a row on Amazon Keyspaces using the GoCQL driver

I created a keyspace in eu-west-3. When I try with the same query in cqlsh it works but with golang doesn't. Someone can help me? cluster := gocql.NewCluster("cassandra.eu-west-3.amazonaws.com:9142") cluster.ConnectTimeout = time.Second *…
nico
  • 11
  • 1
1
vote
0 answers

Is there an alternative for the unsupported CQL IN operator in Amazon Keyspaces?

For Increasing data fetch performance, we are migrating to amazon keyspace from some relation tables. But While using amazon keyspace having multiple problems due to lack of cql support Since it doesn't have IN clause support, Is there any…
Rachit
  • 43
  • 6
1
vote
2 answers

Cassandra(Amazon keyspace) Query Error on clustered columns

I am trying execute query on clustering columns on amazon keyspace, since I don't want to use ALLOW FILTERING with my native query I have created 4-5 clustering columns for better performance. But while trying to filter it based on >= and <= with on…
Rachit
  • 43
  • 6
1
vote
0 answers

Executing DDL statements inside Spark is slow and not in order

I'm trying to execute multiples commands with cqlSession inside spark, but the commands is very slow and didn't respect the order and fail to create the table. i need to wait delete to create a new table. delete: connector.withSessionDo(cqlSession…
1
vote
1 answer

Problem to read and write aws keypace with spark connector

I'm trying to write read and write some data on aws keyspace, but the following message appears. Versions: Spark: 2.4.6 Cassandra connector: 2.5.2 Scala: 2.11.10 New and old version problems occurs too.
1
vote
2 answers

Alternative to IN clause not supported in Amazon Keyspaces

I have en existing DSE 6 node cluster on AWS that performs very well. I would like to move the data to the "Cassandra compatible" Amazon keyspaces but after moving some data, I have found there is no "IN" clause. I use the field mentioned in the…
1
vote
0 answers

Cannot connect Amazon Keyspaces using rails CQL

I'm using the below configuration in the rails config/cequel.yml. development: host: 'cassandra.ap-south-1.amazonaws.com' username: 'username' password: 'password' port: 9142 keyspace: 'keyspace' max_retries: 3 retry_delay: 0.5 …
Neeraj Sharma
  • 73
  • 1
  • 6
1
vote
2 answers

Why does writing to AWS Keyspaces with spark-cassandra-connector return "Unsupported partitioner"?

I'm trying to write some data in aws keyspace with spark, but the follow message error shows: Exception in thread "main" java.lang.IllegalArgumentException: \ Unsupported partitioner: com.amazonaws.cassandra.DefaultPartitioner Being so, I tried…