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
1
vote
1 answer

Is it possible to drop a column from AWS Keyspaces table?

I need to write roll-in and roll-back scripts for AWS Keyspaces. Roll-in is ALTER TABLE my_table ADD ( next_value_1 double, next_value_2 double, ); What roll-back script should be? According to what's written at Tutorial: Delete data in an…
Yura
  • 969
  • 14
  • 33
1
vote
2 answers

Getting AlreadyExistsException when creating table, even table is not found in aws keyspace

I am trying to create a table through following query on aws keyspace. it is throw an exception that "com.datastax.oss.driver.api.core.servererrors.AlreadyExistsException: Object ascend_dev.ascend_r_c_zzzj already exists", even table not found in…
Junaid Ishaq
  • 21
  • 3
1
vote
1 answer

"LIKE" and "ILIKE" queries in AWS Keyspaces

As there is no support for custom index in AWS Keyspaces what would be the best solution / pattern to be able to run LIKE or ILIKE queries on specific columns of a Cassandra Table? In vanilla Cassandra, you can use SSTable secondary index to use…
zenbeni
  • 7,019
  • 3
  • 29
  • 60
1
vote
1 answer

AWS Keyspaces effective pagination

I have to jump to specific rows in AWS Keyspaces table. In specific I am doing pagination so I want to be able to jump to a specific page. Do I have any options for that? For example, I have to fetch 100 rows after 1e+6 row. And ofc I want to do it…
Ilya
  • 45
  • 1
  • 10
1
vote
1 answer

Amazon Keyspaces ALLOW FILTERING without all keys in Node JS

I have a table with two keys KeyA and KeyB on AWS Keyspaces. I open a CQL editor on AWS Console and run the query: SELECT fields FROM table WHERE KeyA = 'value' AND KeyB = 'value' LIMIT 10 ALLOW FILTERING It returns 10 rows, I copy the query to my…
Miguel Angel Acevedo
  • 299
  • 5
  • 14
1
vote
2 answers

Cannot write on table on Amazon Keyspaces

I have a problem to write data on aws keyspace with spark conector. This message below shows: ERROR QueryExecutor: Failed to execute: com.datastax.spark.connector.writer.RichBoundStatementWrapper@681c47f5…
Alan Miranda
  • 125
  • 1
  • 8
1
vote
3 answers

When I try fetch data from Amazon Keyspaces with Pyspark, I get Unsupported partitioner: com.amazonaws.cassandra.DefaultPartitioner Error

I'm not experienced in Java or Hadoop ecosystem. I configured my Spark cluster to connect to Amazon Keyspaces by using spark-cassandra-connector from Datastax. I'm using Pyspark to fetch data from Cassandra. I can successfully connect to…
Mehmet Ali Peker
  • 701
  • 1
  • 6
  • 19
1
vote
2 answers

How to list the available tables in different keyspaces in Amazon Keyspaces/Cassandra?

I am trying to implement an application using AWS Keyspace Cassandra and Cassandra Python driver. I had created 3 keyspaces in my AWS console. I am trying to find if there is any query which can list down all the available tables in all 3 keyspaces…
Shailendra
  • 33
  • 6
1
vote
2 answers

How to connect AWS Keyspace using Django Cassandra Engine?

I am trying to set a django app and connect it to AWS Keyspaces. Trying to do it using django-cassandra-engine. I'm currently using this setup in the settings, but it's not working. ssl_context = SSLContext(PROTOCOL_TLSv1_2) …
Amit Nanda
  • 41
  • 6
1
vote
2 answers

Exceeded the number of columns that can be updated simultaneously

I'm trying to load data to the Amazon Keyspaces Managed Cassandra. It's working fine for some of the simple objects but when I tried to load a table with 286 columns im getting the error Exceeded the number of columns that can be updated…
Umamaheswaran
  • 3,690
  • 3
  • 29
  • 56
1
vote
2 answers

Micronaut fail to connect to Keyspaces

I'm trying to integrate my service with AWS Cassandra (Keyspaces) with the following config: cassandra: default: advanced: ssl: true ssl-engine-factory: DefaultSslEngineFactory metadata: …
Yonatan Karp-Rudin
  • 1,056
  • 8
  • 24
1
vote
2 answers

How to solve "Range delete requests are limited in the amount of items that can be deleted in a single range" issue in aws Keyspaces?

I'm using Aws Keyspaces with c# and first i do select from table to delete by partition keys and then trying delete many rows from table with where clause: var daysToDelete = DateTimeOffset.UtcNow.AddDays(-1); foreach (var result in…
Taifunov
  • 533
  • 1
  • 4
  • 9
1
vote
2 answers

Cassandra | AttributeError - 'NoneType' object has no attribute 'is_up'

I have two structurally identical tables in a Cassandra database. They are both in the same keyspace. I need to move data from one table to another. I create a standard CSV file using COPY/TO and now I want to upload the content using COPY/FROM…
Nurzhan Nogerbek
  • 4,806
  • 16
  • 87
  • 193
1
vote
1 answer

Is it possible to get a callback from Cassandra after the INSERT operation that the record was created successfully?

I have encountered very strange behavior and am trying to understand in which cases this may occur. In my Python application, I access the Cassandra database via the driver. As you can see below, first, I do an INSERT operation, which creates a…
Nurzhan Nogerbek
  • 4,806
  • 16
  • 87
  • 193
1
vote
1 answer

Enable Json Insert on Amazon Keyspaces

I am migrating from an hosted Cassandra to Amazon Keyspace. Some production processes use the Cassandra Json Insert. When I try to run one of this processes to store data in Amazon Keyspaces I get the following error: Unsupported statement:…
Stefano Castoldi
  • 193
  • 2
  • 10
1 2 3
4
5 6 7 8